On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / sasi
the best way to do this use the slowy changing dimension in
the mappings-->wizzard-->slowly changing dimension-->type1
here u need to select the source and target tables.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Repository user profiles
What is union transformation in informatica?
What is a mapplet/worklet in informatica?
Have you worked with/created Parameter file
How is union transformation utilized?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a shortcut and copy in Informatica and how two are different with each other?
What is a standalone command task?
What is the fact table?
What are the features of complex mapping?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How many ways a relational source definition can be updated and what are they?
How can you increase the performance in joiner transformation?