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
- 13230 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 tasks that can be performed using sq?
How to load the data from people soft hrm to people soft erm using informatica?
How can we improve session performance in aggregator transformation?
Explain your project of banking domian.
How to implement security measures using repository manager?
How does the aggregator transformation handle null values?
expain about the tune parameters?
Can we create multiple integration service on single repository?
What is the need of an ETL tool?
what is the -ve test case in your project.
How do we call shell scripts from informatica?
how to load rows into fact table in data warehouse
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How many types of sessions are there in informatica.please explain them?
What is the benefit of session partitioning?
