HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
- 6 Answers
- 12014 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish potdar
Use a seq generator to tag row number to each row(use reset
option so that it will be reset to 1 after the session is
complete). OR use rownum in Source qualifier query.
Once the rows are tagged,pass constant 1 to aggregator to
get the count, join the aggregator output with source
pipeline USING JOINER(since you cannot join heterogeneous
rows using any other transformation). Use router to route
the rows to different targets using appropriate group
expression.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
What is dimensional table? Explain the different dimensions.
Write the unconnected lookup syntax?
What is dimensional table?
How do you remove duplicate records in informatica? And how many ways are there to do it?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
EXL informatica Questions
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Name at least 5 different types of transformations used in mapping design and state the use of each.?
draw informatica architecture 8.6 ?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain in detail about scd type 1 through mapping.
Explain scd type 3 through mapping.
