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
- 40819 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
how to create user defined function (udf) in informatica
What all join we can perform in LOOKUP transformation?
what is degenerated dimension?
What is meant by lookup transformation?
How to do unit testing in informatica? How to load data in informatica ?
How to load the data from a flat file into the target where the source flat file name changes daily?
How might you approve all mappings in the archive all the while?
What are the different transaction levels available in transaction control transformation?
How many types of sessions are there in informatica.please explain them?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
where to store informatica rejected data?
Can we get 1st record through Informatica(without sequence number).
What is resilience time?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
can you please explain me pre session and post session options?
