Can we update a target table (without primarykey) by using
update strategy transformation?
- 4 Answers
- 21920 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 are the mapping paramaters and mapping variables?
What are the types of presistent cache in look up tr.
what are types of dimentions?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
what is the -ve test case in your project.
How to load the source table into flat file target(with columns) in informatica?
Can you start a batches with in a batch?
What is joiner transformation?
What is a look up function? What is default transformation for the look up function?
What is a repository? And how to add it in an informatica client?
Teradata 
