Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10309 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / yaseen
sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.
And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update
Plz correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What do you understand by SOA of Informatica?
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 Cognos script editor?
wat are deployement groups in informatica, how it will be used for developers
What are the different ways to implement parallel processing in informatica?
is it possible to index the data in cache of lkp transformation ?
Differences between version 7.x and 8.x.
Explain in detail scd type 2 through mapping.
Explain in detail about scd type 1 through mapping.
What are the guidelines to be followed while using union transformation?
What does reusable transformation mean?
What are the different types of transformation available in informatica.
What is target load order?
What is rank transformation?
