Interested to Buy Any Domain ? << Click Here >> for more details...
Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 12832 Views
- I also Faced
- E-Mail Answers
Answer Posted / rani
Take Source Qualifier,next place sorter t/f,select option Distinct in sorter and load it in Unique_target.
Take lookup transformation and lookup on target and compare it with source, when a record occurs more than 1 ,delete that record from target using Update strategy -DD_DELETE 2 and load
in Duplicate_target.This is a source in another pipeline and take unconnected lookup and write lookup override like count(*) having >1 then load them in Duplicate_target.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Define pmcmd command?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the difference between a repository server and a powerhouse?
Write the advantages of partitioning a session?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the need of an ETL tool?
What is the difference between router and filter?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the use of target designer?
Can we create multiple integration service on single repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What does “tail –f” command do and what is its use as an Informatica admin.
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 many dimensions are there in informatica?
