Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16638 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / murali raju
Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the different components of powercenter?
Quickly characterize reusable change?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Performance tuning( what you did in performance tuning)
Mention some types of transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
On which transformations you created partitions in your project?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is main use of mapplet?
What is source qualifier transformation in informatica?
What is a surrogate key?
Explain the different kinds of facts.
How to join three sources using joiner?
