how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / srinivas
hi
experts, i suppose to eswar 's answers
lookup transformation is passive transformation .ie it cant
reduce rows after condition satisfy or nt
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain the aggregator transformation?
What are the static cache and dynamic cache in informatica?
How are indexes created after completing the load process?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is confirmed fact in dataware housing?
What is the use of code page?
How to update source definition?
How to Create a folder using pmrep command?
What are the types of schemas we have in data warehouse and what are the difference between them?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is an Integration service in Informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Where do we use mapping variables in informatica?