Interested to Buy Any Domain ? << Click Here >> for more details...
S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used?
- 5 Answers
- 14804 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / madhava
In this scenario generally using the two transformations
(Joiner&UpdateStrategy Tx) if S1 and S2 are different
sources or Flat files;
Else if both are in same sources as of relational then
join it in SourceQulaifier Tx itself in this case no need
for Joiner tx.
1) Joiner Tx will join the S1 and S2 by using common
fields; here S2 is the Master table.
2)In UpdateStrategy Tx. Condition is like IIF
(s2.empno=s1.empno,1,0)
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
What is update strategy transform?
What is the need of etl tools?
What are the features of complex mapping?
What is meant by a domain?
What is the benefit of session partitioning?
What is difference between a gateway node and worker node?
What is a filter transformation?
What is a predefined event?
Where can we find the throughput option in informatica?
Briefly define reusable transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the Process to creating lookup transformation in informatica
is it possible to index the data in cache of lkp transformation ?
