Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 13461 Views
- I also Faced
- E-Mail Answers
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
What does update strategy mean, and what are the different option of it?
What is a grid in Informatica?
How do you load alternate records into different tables through mapping flow?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain the etl program with few examples.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
lookup transformation with screenshots
How to load last n records of file into target table - informatica
Define joiner transformation?
What is decode in informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Mention few power centre client applications with their basic purpose?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are some examples of informatica etl programs?
How to do unit testing in informatica?
