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
- 14730 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 might you approve all mappings in the archive all the while?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Can we get 1st record through Informatica(without sequence number).
Explain the use of aggregator cache file?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to do the error handling of if ur source is flatfiles?
what is $$$$?
What is lookup change?
can u give example for factless fact table
What are the types of schemas we have in data warehouse.
How big was your fact table
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to handle decimal places while importing a flatfile into informatica?
What is the need for an etl tool?
What is substr in informatica?
