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 |
What are the measure objects?
Explain the tuning lookup transformation - informatica
what is the necessity to use update strategy?(except for updates)
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What if the source is a flat-file?
what is mystery dimension?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,