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
- 41337 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
is it possible to index the data in cache of lkp transformation ?
What is option by which we can run all the sessions in a batch simultaneously?
What is the use of source qualifier?
How many numbers of sessions can one group in batches?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
draw informatica architecture 8.6 ?
What is the advantage of informatica?
Define mapplet?
Mention few power centre client applications with their basic purpose?
Explain sessions?
What is a passive transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the informatica workflow?
Which development components of informatica have the highest usage?
