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
- 23443 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ratalarayudu
hi ,
Yes we can update a target table without having a primary
key. we have a property TARGET UPDATE OVERIDE .By overring
we can update .
Regards,
Rayudu.
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / 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 |
Answer / mithilesh kumar rai
With Same logic with Update Strategy tr,
just Select Primary Key Option in Target Table Definition.
It will work without defining the Target table.
Regards
Mithilesh Kumar Rai
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / maheedhar
I said No,Kindly correct me if am wrong.......
| Is This Answer Correct ? | 1 Yes | 8 No |
what is session parameters?
How to extract sap data using informatica?
how can we calculate fact table size?
how to get flatfile containg 10 records half records one target another half another target
Describe the impact of several join conditions and join order in a joiner transformation?
All active transformations r passive or not?
What do you mean by channel change?
Different sorts of metadata that stores in the storage facility?
Can we insert and update a target table without using update strategy transformation?How?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
what r the values tht r passed between informatics server and stored procedure?
what is the use of Data Mart?
Teradata 
