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
- 12905 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
Define filter transformation?
Tell me about MD5 functions in informatica
What is option by which we can run all the sessions in a batch simultaneously?
Does an informatica transformation support only aggregate expressions?
How can you validate all mappings in the repository simultaneously?
How can repository reports be accessed without sql or other transformations?
Name the different lookup cache(s)?
Which development components of informatica have the highest usage?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How we can create indexes after completing the load process?
What is joiner transformation?
State the differences between sql override and lookup override?
How many input parameters can exist in an unconnected lookup?
Explain the code page compatibility?
Explain the mapping variable usage example in informatica
