Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 14831 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhinav
By using an UPDATE STARTEGY transformation.
DD_UPDATE = If the record alreadye exists
DD_INSERT = If the record is a new one
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between mapping parameter and mapping variable?
What do you mean incremental aggregation?
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 are some examples of informatica etl programs?
How to generate sequence numbers using expression transformation?
How can repository reports be accessed without sql or other transformations?
Where are the source flat files kept before running the session?
What are the transformations that are not supported in mapplet?
Sequence generator, when you move from develoment to production how will you reset
Explain why we use partitioning the session in informatica?
What are the databases that informatica can connect to windows?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Design time, run time. If you don't create parameter what will happen
What is data caches/ index caches?
Define enterprise data warehousing?
