how would u estimate the size of Lookup transform data and
index cache?
what is meant by drill through?(Mascot)
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
What are the types of Data Warehouse applications?
where is the cache (lookup, index) created and how can you see it.
What is staging area referring to?
SCD2 will work on only dimension tables as well as fact Table?
What exact we can see in table?
What is Data Vault???
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 is a test load?
List few etl bugs?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?