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
- 41171 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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the sql query overwrite in source qualifier in informatica
What all join we can perform in LOOKUP transformation?
what is the size of your data warehousing?
What are the informatica performance improvement tips
design of staging area?
How to join three sources using joiner? Explain though mapping flow.
How to create a non-reusable instance of reusable transformations?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a node in Informatica?
What is the meaning of decode in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the tuning techniques you applied during your last project
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
