Can we update a target table (without primarykey) by using
update strategy transformation?
- 4 Answers
- 22723 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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Enlist the differences between database and data warehouse.
server hot-ws270 is connect to Repository B. What does it mean?
Explain transaction control transformation in informatica
scenario where i can use only concurrent execution of workflow.
How to load the data from a flat file into the target where the source flat file name changes daily?
What is joiner change?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can we override a native sql query within informatica? Where do we do it?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the difference between informatica 7.0 and 8.0?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are junk dimensions?
COM components can be used in Informatica
Why do we need informatica?
