suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answer Posted / abhishek kumar
in aggregator---
record(field) group by
total_record <- count(record)
router---
condition1 <- (total_record)/2
default
send to target
condition1 to target first and
default to target second.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
How can a transformation be made reusable?
What is a repository manager?
What are the informatica performance improvement tips
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the components of Informatica? And what is the purpose of each?
What are the advantages of informatica?
Do you find any difficulty while working with flat files as source and target?
What is repository manager?
What is informatica powercenter repository?
What is target load order?
What is a standalone command task?
How does the aggregator transformation handle null values?
what is the size of u r source(like file or table)?
Different qualification between a related rotate toward the sky and isolates look upward?