Can we update a target table (without primarykey) by using
update strategy transformation?
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 |
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is a sequence generator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is flashback table ? Advance thanks
how to insert header after each group.
What are the main features of Oracle 8i with context to datawarehouse?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
What is polling in informatica ?
What is confirmed dimension and fact?
why union is active transformation?
Where can we find the throughput option in informatica?
Issue with Update override at Target table in Informatica.