when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / balu
above cases as well as if you want to get single port from
the lookup table then you should go for unconnected lookup
transformation.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
Which version configuration tool used in ur project?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is informatica metadata and where is it stored?
Explain how to import oracle sequence into informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain the informatica workflow?
what is Active lock explain
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How might one distinguish in the case of mapping is right or not without associating session?
What are the types of lookup transformation?
How can you increase the performance in joiner transformation?