Explian the connected and unconnected lookup transformation
Answer / hari
Connected lookup
1.input ports are connected through pipeline
2.we can have more inputs and more outputs
3connected lookup we can use both static and dynamic cache
4.if condition not match default it give values
Unconnected lookup
1. Inputs are connected through calling :LKP from expression
2.inputs are more and output returns one
3.only static cache can use
4.if condition not match it gives nulls
| Is This Answer Correct ? | 0 Yes | 0 No |
can you use flat file for repository?why?
Explain about cumulative Sum or moving sum?
Explain the different kinds of facts.
What are the session parameters?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
What are the types of maping wizards that r to be provided in Informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain joiner transformation in informatica
What is the Difference between DSS & OLTP?