my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
- 4 Answers
- 7794 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answer Posted / chandra
take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1
SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2
| Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
What is resilience time?
In how many ways we can create ports?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
State the limitations where we cannot use joiner in the mapping pipeline?
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
Explain Dataware house architecture .how data flow from intial to end?
Mention few advantages of router transformation over filter transformation.
How to load the data from a flat file into the target where the source flat file name changes daily?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
whats the logic to load the lower level of granularity of data to fact table.
What differs when we choose the sorted input for aggregator transformation?
What is the session task and command task?
can we override a native sql query within informatica? Where do we do it?
Scheduling properties,whats the default (sequential)
