diff b/w dwh & data mart
diff b/w star schema & snow flake schema
diff b/w fact table & dimension table
what are the contents in requirement specification
what are the docs needed for testing
draw ur proj architecture
No Answer is Posted For this Question
Be the First to Post Answer
what is the use of structures?how many nodes can u create in a structure?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
how do u identify the changed records in operational data?
what do u do when DB time takes more?in sap bi
Is apache nifi an etl tool?
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.
how do u implement unconn.stored proc. in a mapping?
how would u estimate the size of Aggregator transform data and index cache?
When do we analyze the tables?
Explain and compare etl & manual development?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are the key benefits of ETL Testing?