what are the production issues in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
what is the main role of FI on business
Explain what is etl process? How many steps etl contains explain with example?
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.
what are the concerns of OLTP and DSS systems?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is the difference steps for data modeling?
Mention few test cases and explain them?
What are the different Lookup methods used in Informatica?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is HISTOGRAM? how to generate statistics?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is etl process. How many steps etl contains explain with example?