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
what is the size of u r source(like file or table)?
Explain the different dimensions.
What is workflow? What are the components of the workflow manager?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is DR strategy for Informatica project?
Explain lookup transformation is active in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
define galaxy repository in informatica
How many input parameters can exist in an unconnected lookup?
expain about the tune parameters?
How to load the data from people soft hrm to people soft erm using informatica?
Informatica Checkpoints
What is meant by a domain?
Is there any way to read the ms excel datas directly into informatica?
Explain pushdown optimization and types in informatica