why cant we put a sequence generator or upd strategy
transformation before joiner transformation?
Answer Posted / srinivas
Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
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 a code page?
What differs when we choose the sorted input for aggregator transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is dimensional table?
Write the prerequisite tasks to achieve the session partition?
explain about unit testing? in real time?
How to generate sequence numbers?
What is an unconnected transformation?
What do mean by local and global repository?
What does reusable transformation mean?
What is informatica?
How would you join a node to the already existing domain?
How might you approve all mappings in the archive all the while?
What is the benefit of partitioning a session?