Interested to Buy Any Domain ? << Click Here >> for more details...
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.
2054list and discuss two approaches for updation of target table in Informatica and how they are different.
2107you 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 6337where are the log files generally stored.Can you change the path of the file.what can the path be?
2434what 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 4226
What are snapshots?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what are the concerns of OLTP and DSS systems?
What is abap? What are idocs?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is partitioning? Explain about round-robin, hash partitioning.
how do u extract data from different data sources explain with an example?
what is pmrep command?
what is the meant by Normalization and de-normalization?
What is tracing level?
Is hadoop a etl tool?
What is etl tool in hadoop?
how do u really know that paging to disk is happening while u are using a lookup transform?
Can u access a repository created in previous version of Informatica?
