Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 11310 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
What i have understood after seeing your problem is like if your source contains 1,2,1,2,3 then only 3 is taken as unique and 1,2 will be considered as duplicate values.
SRC->SQ->SRT->EXP(to set flags for dup)->ROUTER->JOINER->EXP->RTR->2TGTS
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
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
EXL informatica Questions
In how many ways we can create ports?
Which transformation is needed while using the Cobol sources as source definitions?
Which are the different editions of informatica powercenter that are available?
How union transformation is used?
how we can load rejected record's at run time?(not through bad files)
What is the sequence generator transformation in informatica?
Can we create multiple integration service on single repository?
How do you convert single row from source into three rows into target?
r u done any partitions in ur project?
generate date / time dimension in informatica
How big was your fact table
Why union transformation is an active transformation?
