how to design mapping half of source table records into one
target and remaining half into another target

Answers were Sorted based on User's Feedback



how to design mapping half of source table records into one target and remaining half into another..

Answer / akash

There are 2 ways through which we can achieve this:
Through informatica transformations: Source Qualifier /
Aggregator and Expression

1. Take count through an aggregator or source qualifier.
Add a port (say record_id) from sequence generator to give
the record number.
Mark router condition as -
where record_id < = (count / 2)
send this group to one target and default group of router
to other target.

2. Use the following query in Source Qualifier:
SELECT KEY_field,
description,
(CASE WHEN ROWNUM <= ((SELECT COUNT(*) FROM TEMP_TABLE)/2)
THEN 1
ELSE 2
END) AS FLAG
FROM table_name

In the above key_field and description are the required
fields from source table.

The result will be of the type:

KEY_FIELD DESCRIPTION FLAG
1 ABC 1
2 JJJ 1
3 XYZ 2
4 PQR 2

Use a router on the condition of port FLAG to map data to
targets.

Is This Answer Correct ?    2 Yes 1 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / raj

hii Sbvp... can you please elaborate the above situation
clearly.... for when the source is a flat file....

thank you

Is This Answer Correct ?    0 Yes 0 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / raj

Hi SBVP , thanks for your answer.... if i dont know the
number of records coming from my source flat file what can i
do? please tell me

thank you

Is This Answer Correct ?    0 Yes 0 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / sbvp

raj this is my mail id bhanuar.inf@gmail.com.
chat with me on evening times 7-8
i will discuss with u

thanks
sbvp

Is This Answer Correct ?    0 Yes 0 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / neha

IT is not possible thru Informatica, you need to write Unix
Script for this.

Is This Answer Correct ?    2 Yes 3 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / ravi

by using router transformation

Is This Answer Correct ?    2 Yes 4 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / sbvp

hi raj

when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)

take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok


thanks
sbvp

Is This Answer Correct ?    0 Yes 2 No

how to design mapping half of source table records into one target and remaining half into another..

Answer / sbvp

S->SQ->EXP->ROUTER->TRG
| |
| |-->TGR
SEQ<-

IN RTR SEQ<=n
SEQ>=n

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,


Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  


How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,


How to extract sap data using informatica?

0 Answers  


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??

0 Answers  






Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,


How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,


Categories