How to extract original records at one target & Duplicate
records at one target?
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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How might one distinguish in the case of mapping is right or not without associating session?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Repository user profiles
Why update strategy and union transformations are active? Explain with examples.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is Active lock explain
can u give example for factless fact table
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is pmcmd command?
Explain load alternative records / rows into multiple targets - informatica
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.
How to do unit testing in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How do you load first and last records into target table?