wht target override?wht advantages it has compare to target
update?
Answers were Sorted based on User's Feedback
Answer / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rkumar.etl
when table is having huge amount of records and performance
is the key factor to implement the target overrride ..if we
use update override it will take more time than the target
override.
| Is This Answer Correct ? | 4 Yes | 3 No |
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What is status code in informatica?
How will you combine 3 different sources with a single source?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
What is Session and Batches?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
how to improve performence by using sorted input in aggrigator t/r.
what is the command to get the list of files in a directory in unix?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
what is the complex transformation you used in informatica
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks