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
- 12513 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 incremental aggregation?
What is a standalone command task?
What are the restrictions of union transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain the different kinds of facts.
Have you worked with/created Parameter file
Is there any target staging area in informatica not staging area
How do you handle two sessions in Informatica
Explain the informatica workflow?
Is stop and abort are same in informatica?
How we can create indexes after completing the loan process?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the different clients of powercenter?
