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
- 14944 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
How do you update the records with or without using update strategy?
What are the prerequisite tasks to achieve the session partition?
What is union transformation?
How to generate sequence numbers?
What is Index Caches size?
How do you load first and last records into target table?
Can we create a Integration service without a Repository service and vice versa?
Under which circumstances, informatica server creates reject files?
Explain sessions?
What are the differences between a connected lookup and unconnected lookup?
waht type of interface is used for testing the data in informatica
What is session task and command task?
What the difference is between a database, a data warehouse and a data mart?
How can you increase the performance in joiner transformation?
What is the function of union transformation?
