Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 11254 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
Create the mapping as below to load Unique records and duplicate records each in separate targets
Source->SQ->Sorter->Aggregator->Router-> Tgt_Unique
-> Tgt_Duplicate
In aggregator use group by on all ports.
and define a port OUTPUT_COUNT = COUNT(*)
In the router define two groups OUTPUT_COUNT > 1 and OUTPUT_COUNT = 1; Connect the outputs from the first group
OUTPUT_COUNT > 1 to tgt_Duplicate and OUTPUT_COUNT = 1 to Tgt_Unique
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
tell me about your project functionality
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 the cumulative sum and moving sum?
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
update strategy transformation in informatica
Explain transaction control transformation in informatica
What is persistent lookup cache?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain in detail scd type 2 through mapping.
Explain Dataware house architecture .how data flow from intial to end?
explain about unit testing? in real time?
What is joiner change?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
