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
- 14733 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 is the way to execute pl/sql script using informatica mapping?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How can you increase the performance in joiner transformation?
What is repository manager?
What is a stored procedure transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the new features of informatica 9.x in developer level?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How do you remove duplicate records in informatica? And how many ways are there to do it?
explan ur project architecture?
generate date / time dimension in informatica
What does cheating measurement mean?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the types of schemas we have in data warehouse.
