What is a diff between joiner and lookup transformation
- 16 Answers
- 90861 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Different sorts of metadata that stores in the storage facility?
What is repository manager?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the restrictions of union transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What happens when a session fails and you click on recover?
Explain about cumulative Sum or moving sum?
What is the benefit of session partitioning?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Plz can any one say me how to get the informatica certification materials and dumps
What is target load order?
What do you mean by filter transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the different versions of informatica?
