Hi,
Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
Answer Posted / vaibhav fadnaik
Do you have anything for cognos, for 2.6years.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Do we need an etl tool?
What is fact? What are the types of facts?
how would u estimate the size of Lookup transform data and index cache?
Compare etl & elt?
Explain what are the various etl tools in the market?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Explain the difference between etl tool and olap tools?
What is a lookup table in etl?
how many maximum session supports to multiload in teradata ??
What do you understand by active and passive transformations?
How etl testing is different from database testing?
Can we create Hierarchies in generic datasources?
what are the types in error loging?
What are the different Lookup methods used in Informatica?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.