for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
Answers were Sorted based on User's Feedback
Answer / sai krishna karri
only the answer 3 given by Amit is the valid answer.
| Is This Answer Correct ? | 0 Yes | 8 No |
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 system requirement(SR) & business requirement(BR)?
can we override a native sql query within informatica? How do we do it?
To import the flat file definition into the designer where should the flat file be placed?
What is xml source qualifier transformation in informatica?
Does Facttable Normalized or Denormalized?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
how to delete duplicate records by using filter transfermation?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
what is the difference between mapplet & stored procedure?