on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
Answer Posted / rajendra kommineni
WE CAN USE SCD TYPE1
i.e BY USING UPDATE STATERGY
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
How can one identify whether mapping is correct or not without connecting session?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is fact table? Explain the different kinds of facts.
Define filter transformation?
What is meant by LDAP users?
Which version configuration tool used in ur project?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the tuning techniques you applied during your last project
What are the differences between source qualifier and joiner transformation?
What are the different components of powercenter?
How do you load only null records into target? Explain through mapping flow.
What are mapplets?
What do you mean by filter transformation?
How do you change a non-reusable transformation to reusable transformation?