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
- 23672 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 |
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
What is update strategy transform?
how to design mapping half of source table records into one target and remaining half into another target
what are factless facts? And in which scenario will you use such kinds of fact tables.
How union transformation is active ?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Why we use ENABLE HIGH PRECISION in session properties?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
how we load the data from source to staging area
EXL informatica Questions
What is Code Page Compatibility?
Teradata 
