Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 10092 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
this can achieved using Update statergy
we have option in UPD or Target update override
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Enterprise data warehouse your projects phase by phase explain?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How can you increase the performance in joiner transformation?
can u give example for factless fact table
What is the commit type if you have a transaction control transformation in the mapping?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
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 ?
How many types of sessions are there in informatica.please explain them?
What is the function of aggregator transformation?
What do you mean incremental aggregation?
Which is the t/r that builts only single cache memory?
How can repository reports be accessed without sql or other transformations?
