How will you update the row without using update statergy?
Answer Posted / bobby
I think in the session Properties, we can update or insert
the record with out using update strategy in the mapping.
I think it works. If i am wrong let me know
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
Where do we use mapping variables in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a code page?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can we remove the duplicates from flat file source?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you handle two sessions in Informatica
What is a joiner transformation?
What do you mean by worklet?
Explain in detail about scd type 1 through mapping.
Explian the Process of deployment groups in informatica
Explain the etl program with few examples.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is enterprise data warehousing?