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 is a grid in Informatica?
How can we create index after completion of load process?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Which is the t/r that builts only single cache memory?
Write the program through which the records can be updated?
comonly how meny mappings r there in Banking projects?
What are the unsupported repository objects for a mapplet?
how to insert header after each group.
Which files are created during the session rums by informatics server?
What is the Hierarchy of DWH?
Useful UNIX commands regular/frequently used
server hot-ws270 is connect to Repository B. What does it mean?