Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 40667 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / chetan
I/p
A
B
B
C
D
D
need to load A.C in one tgt and B,B,D,D in another target table.
SQ o/p should be given to aggregator. group by first column.create another port(v_count) with count(*).
SQ o/p should be passed to joiner to join aggr and SQ(source).
o/p looks like after joinning
A 1
B 2
B 2
C 1
D 2
D 2
use router to route v_count=1 and v_count=2 to different targets.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
How to extract sap data using informatica? What is abap? What are idocs?
Does an informatica transformation support only aggregate expressions?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Design a mapping to load a target table with the following values from the above source?
What is resilience time?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is Data Caches size?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the maplet?
How to open an older version of an object in the workspace?
What is data transformation manager process?
What are the different lookup cache(s)?
How an expression transformation differs from aggregator transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
