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
- 23676 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 |
can u give example for factless fact table
What is sequence generator transformation in informatica?
How will u pas the data with out debugger?
Can i create a lookup table without cache.
i have 2 session s1 execute s2 load first session fail what is the reason?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Is stop and abort are same in informatica?
What is xml source qualifier transformation in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is source qualifier transformation in informatica?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
Teradata 
