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
- 14798 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sushma
I go with Naveen's solution with a small change. I would
replace filter with Router TRFM.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
How do you take back up of repository?
What's the layout of parameter file (what does a parameter file contain?)?
How can a transformation be made reusable?
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 .
What are mapplets? How is it different from a Reusable Transformation?
wf dont have integration severances how you can run?
What are the features of complex mapping?
Can we get 1st record through Informatica(without sequence number).
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
can we override a native sql query within informatica? Where do we do it? How do we do it?
Which means the first record should come as last record and last record should come as first record and load into the target file?
scenario where i can use only concurrent execution of workflow.
How can repository reports be accessed without sql or other transformations?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
