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
- 41708 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 components of workflow manager?
What is Index Caches size?
What is a code page?
What is lookup transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the data movement modes in informatica?
Whats there in global repository
complex mapping ur project u r invlve can u explain and give real time example give me ?
Define mapplet?
Name the different lookup cache(s)?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is meant by lookup transformation?
What do you mean by enterprise data warehousing?
What is decode in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
