Interested to Buy Any Domain ? << Click Here >> for more details...
Can we update a target table (without primarykey) by using
update strategy transformation?
- 4 Answers
- 23659 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zak
1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain sessions. Explain how batches are used to combine executions?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the use of source qualifier?
What does reusable transformation mean?
What are some examples of informatica etl programs?
What is Data Caches size?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How we can use union transformation?
COM components can be used in Informatica
explan ur project architecture?
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
what are the deliverables?in your project?
can we override a native sql query within informatica? How do we do it?
If informatica has its scheduler why using third party scheduler?
What are the measure objects?
