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
- 12718 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
What is enterprise data warehousing?
What is rank transformation in informatica
Explain the difference between a data warehouse and a data mart?
What is decode in informatica?
What is olap (on-line analytical processing?
How to delete duplicate row using informatica?
How to extract sap data using informatica?
Enlist the tasks for which source qualifier transformation is used.
What are the components of the workflow manager?
What is the use of an aggregator cache file?
What is meant by pre and post session shell command?
How to create the source and target database connections in server manager?
How many numbers of sessions can one group in batches?
Separate from an archive server and a powerhouse?
what are the deliverables?in your project?
