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
- 14564 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
What happens when a session fails and you click on recover?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a passive transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain direct and indirect flat file loading (source file type) - informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain about cumulative Sum or moving sum?
Can u generate reports in Informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the different types of repositories created using informatica?
What is the need of an ETL tool?
