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.
1639list and discuss two approaches for updation of target table in Informatica and how they are different.
1739you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
3 5186where are the log files generally stored.Can you change the path of the file.what can the path be?
1934what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
1 3567
What are various etl tools in the market?
What is Data Vault???
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
How to increase performance without changing anything in mapping.( In prod)
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 meaning of upgradation of Repository?
what are the reporting tools and difference between them?
what is dynamic insert?
how do u really know that paging to disk is happening while u are using a lookup transform?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is initial load and what is full load?
what is pmrep command?
what is Forward,Reverse and Re_engineering?
Explain the use lookup tables and Aggregate tables?
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 ?