how to design mapping half of source table records into one
target and remaining half into another target
- 8 Answers
- 12683 Views
- ABC, I also Faced
- E-Mail Answers
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 |
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
Do you have knowledge in ralph kimball methodology
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
How do you implement unconn. Stored proc. In a mapping?
How do you handle two sessions in Informatica
have you developed documents in your project? and what documents we develop in realtime?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What are the different types of transformation available in informatica.
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Explain scd type 3 through mapping.
Teradata 
