Interested to Buy Any Domain ? << Click Here >> for more details...
how to design mapping half of source table records into one
target and remaining half into another target
- 8 Answers
- 15337 Views
- ABC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Name the different lookup cache(s)?
Write the different tools in the workflow manager?
wf dont have integration severances how you can run?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain what are the different types of transformation available in informatica.
What is the Rank index port in Rank transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is informatica? Why do we need it?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the reusable transformation?
list out all the transformations which use cache?
What is xml source qualifier transformation in informatica?
Explain the types of lookup transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is DR strategy for Informatica project?
