Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com
Answer Posted / frank
Hi,
Can you send me informatica PowerCenter 8 Advanced Administration at frforu12@gmail.com?
Thank you!
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the concerns of OLTP and DSS systems?
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.
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is a staging area? What is the purpose of a staging area?
What is etl process?
what is data modeling?
What are the three tiers in etl?
what is an ETL or ETT? And what are the different types?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain do we need an etl tool?
what is session partitioning?
What is virtual Data Warehousing?
When do we go for the tools in the market?
Do we need an ETL tool? When do we go for the tools in the market?
how do u set partition points in the mapping?