How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 19676 Views
- I also Faced
- E-Mail Answers
Answer Posted / sks
Hi,
Yes you can do it by using Expression transformation as
well. Infact, by using 2 SQ (source qualifier) and using
sql queries (as I explained earlier), you can perform the
required task on relational tables only (but not on flat
files etc).
In the case of flat files as source, you will need to use
Expression transformation. But you also need to use sorter
before expression (otherwise record flag will change for
every incoming record & duplicates won't be traced). The
sequence of transformations will be as follows -
Source -> SQ -> Sorter ->Expression ->Router(or 2 filters) -
>Targets
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the cumulative sum and moving sum?
what is degenerated dimension?
Explain the difference between a data warehouse and a data mart?
What are the types of lookup transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is informatica etl tool?
Explain transaction control transformation in informatica
What is a shortcut and copy in Informatica and how two are different with each other?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is sq transformation?
What is the difference between a repository server and a powerhouse?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is data transformation manager process?
What does command task mean?
Why do we need informatica?
