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.
1838list and discuss two approaches for updation of target table in Informatica and how they are different.
1889you 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 5691where are the log files generally stored.Can you change the path of the file.what can the path be?
2141what 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 3854
What is etl process?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
When do we go for the tools in the market?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what are the session parameters? How do u set them?
Difference between flat files and relational sources?
dimension object created in oracle can be imported in designer?how?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is the use of server?
What is abap? What are idocs?
how do u implement configuration management in Informatica?
Identifying the bottlenecks in various components of Informatica and resolving them.
How to increase performance without changing anything in mapping.( In prod)
what are the types in error loging?
