how can we calculate fact table size?
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
Is This Answer Correct ? | 3 Yes | 2 No |
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
How to recover sessions in concurrent batches?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is domain and gateway node?
What is data merging, data cleansing and sampling?
What is query panel?
how to call lookup qualifer in unconnected look;up
Howmany ways yoU can update a relational source defintion and what are they?
What are the modules in Power Center
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
While migrating the data from one environment to another environment how would you manage the connections?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?