Interested to Buy Any Domain ? << Click Here >> for more details...
if soource is having 10 records how will u insert 20
records to target
- 6 Answers
- 12521 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / saravana
we can user Normalizer transformation, to convert a row into double row and then load it into target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
What is repository manager?
What is meant by active and passive transformation?
how to load rows into fact table in data warehouse
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is persistent lookup cache?
Explain how to import oracle sequence into informatica?
What is a filter transformation and why it is an active one?
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 passive transformation?
Define pmcmd command?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Enlist the tasks for which source qualifier transformation is used.
Informatica settings are available in which file?
Separate from a database, an information bazaar, and an information stockroom?
