how we can update a target table without update strategy and
update override?
- 3 Answers
- 6623 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / bhupal
In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.
| Is This Answer Correct ? | 1 Yes | 0 No |
what are challenges that you faced in testing? give solution to it?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What are variable ports and list two situations when they can be used?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
How many input parameters can exist in an unconnected lookup?
What is the sql query overwrite in source qualifier in informatica
what is lookupoverriding?
Define informatica repository?
I have a flat file, want to reverse the contents of the flat file
What is the difference between view and materialised view?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
Teradata 
