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
- 14734 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / k naveen kumar
Here we have to use lookup and update strategy and filter
Take s1 as source and take lookup on s2 just u will get the
output.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How is union transformation utilized?
Define the various join types of joiner transformation?
how to create user defined function (udf) in informatica
Where can we find the throughput option in informatica?
What is main use of mapplet?
is it possible to index the data in cache of lkp transformation ?
What is the advantage of informatica?
Explain your project of banking domian.
What do you mean by enterprise data warehousing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the benefit of session partitioning?
In informatics server which files are created during the session rums?
Explain load alternative records / rows into multiple targets - informatica
What is the need for an etl tool?
