what is target update override and when we use it?
Answers were Sorted based on User's Feedback
Answer / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.
Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
Is This Answer Correct ? | 0 Yes | 0 No |
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
what is a time dimension? give an example?
How to load a relational source into file taget?
What are the mapping paramaters and mapping variables?
Explain dynamic target flat file name generation in informatica
What is pmcmd command?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
What is version control in informatica ? Advance thanks
How do you join more than 3 flat files in informatica?
I have source like this 1:2;3. so i want to load the target as 123
Which will beter perform IIf or decode?
what is lookup ?