Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravindra kamble
SMP - Symmetric Multi-Processing
MMP - Massively Parallel Processing
| Is This Answer Correct ? | 54 Yes | 14 No |
Post New Answer View All Answers
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
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 is Data Vault???
What is data cleaning?
When do we analyze the tables?
what is Forward,Reverse and Re_engineering?
State the differences between shortcut and reusable transformation
what is Forward,Reverse and Re_engineering?
What is a staging area? What is the purpose of a staging area?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are various etl tools in the market?
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?
How to fine tune mappings?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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
