What is operational data store (ods)?
How to pivot data using informatica when you have variable amount of pivot rows?
What is META DATA information in Data warehousing projects?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is informatica architecture?
What is difference between model & package?
What is data analysis?
Explain is olap databases are called decision support system true/false?
Explain what is type 2 version dimension?
How can we determine what records to extract?
How to answer the question how many fakt table in your datawarehouse and what size it have?
Is there any rownum object from which we can do this?
How to join 3 database like flat file, oracle, db2 in informatrica?