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
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 |
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 |
Answer / neha
IT is not possible thru Informatica, you need to write Unix
Script for this.
Is This Answer Correct ? | 2 Yes | 3 No |
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 |
Answer / sbvp
S->SQ->EXP->ROUTER->TRG
| |
| |-->TGR
SEQ<-
IN RTR SEQ<=n
SEQ>=n
Is This Answer Correct ? | 0 Yes | 3 No |
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
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to extract sap data using informatica?
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??
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.
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?
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.
how the server recognises , if the session fails after loading the 100 records in to the target
Can informatica load heterogeneous targets from heterogeneous sources?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
How can i send first half of the records to one target and Remaining to other target?