Reqirement for data modelling

[deepakqlikview_123]

Hi all,

Can you please suggest what would be requirement for data modelling when we are going to use tables from OLTP environment.

Moreover also suggest how to build schema.

Thanks

[IAMDV]

Deepak,

It's hard to give answer on the fly. I'd suggest you to provide the sample schema and the requirements. There is no hard rule while data modelling because it all depends on the requirements. It's art as much as it's science.

Thanks,

DV

www.QlikShare.com

[deepakqlikview_123]

Hi Deepak,

Thanks for reply.

Please look into below code.

Retail:

load

DealerID

resident OrganisationMaster;

Left Join

load

*,

'' as ret

Resident Dealer1;

After left join

Is dealer id visible in Retail table.

Thanks