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.
1629list and discuss two approaches for updation of target table in Informatica and how they are different.
1731you 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 5163where are the log files generally stored.Can you change the path of the file.what can the path be?
1926what 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 3557
How etl testing is different from database testing?
what are Lookup caches options? Including persistent caches.
Identifying the bottlenecks in various components of Informatica and resolving them.
how many maximum session supports to multiload in teradata ??
What are the steps involved in etl process?
what are the concerns of OLTP and DSS systems?
What are your responsibilities as an etl tester?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are the reports developed in sap bw project and what is the requirement for developing it?
Is hadoop a etl tool?
What is grain of fact?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what are the data modeling tools you have used?(polaris)
When do we analyze the tables?