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
- 12560 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
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the different types of repositories created using informatica?
what is unit testing?tell me proceedure
Define mapplet?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the main issues while working with flat files as source and as targets ?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Separate from a database, an information bazaar, and an information stockroom?
What are some examples of informatica etl programs?
whats the logic to load the lower level of granularity of data to fact table.
How to load data in informatica ?
What is persistent lookup cache?
What are the modules in Power Center
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is pmcmd command?
