Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
- 7 Answers
- 13370 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
I am not confident check itonce let me know,,
Thanks
Srinu
| Is This Answer Correct ? | 5 Yes | 17 No |
Post New Answer View All Answers
What is aggregator transformation in informatica?
What is informatica? Why do we need it?
How do you load only null records into target?
What is the difference between informatics 7x and 8x and what is latest version?
How an expression transformation differs from aggregator transformation?
Explain lookup transformation source types in informatica
How many dimensions are there in informatica?
What is a filter transformation and why it is an active one?
Informatica Checkpoints
Explain scd type 3 through mapping.
draw informatica architecture 8.6 ?
What is the function of union transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is complex mapping?
