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
- 13224 Views
- I also Faced
- E-Mail Answers
Answer Posted / rohan
Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Could you explain what is enterprise data warehouse?
Enterprise data warehouse your projects phase by phase explain?
Which version configuration tool used in ur project?
How would you join a node to the already existing domain?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Design a mapping to load a target table with the following values from the above source?
How to elaborate powercenter integration service?
What is rank transformation in informatica
can u any challenge your project?
Is it possible to create multiple domains on a single Informatica server?
How can we delete duplicate rows from flat files?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to partition the Session?
