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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the designer tools for creating transformations?
How is union transformation utilized?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the maplet?
Explain the types of transformations?
Whats there in global repository
How you can differentiate between connected lookup and unconnected lookup?
What is a surrogate key?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain what are the different types of transformation available in informatica.
What are the different components of powercenter?
Partition, what happens if the specified key range is shorter and longer
Can we get 1st record through Informatica(without sequence number).