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?

Answer Posted / dilip ingole

use sql override in SQ
ans use query as fellow

SELECT NUM,CASE WHEN ROWNUM <=(SELECT COUNT(1)/2 FROM TABLE_NAME) THEN 1 ELSE 0 END FLAG FROM TABLE_NAME;

in informatica filter record based on flag if flag is 1 then send it to one target else to second target

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the status code in stored procedure transformation?

899


what is Active lock explain

2555


Explain informatica architecture - version 8 / 9

864


What is persistent lookup cache?

789


What is pmcmd command?

880


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1985


What is enterprise data warehousing?

804


Clarify the aggregator change?

783


What is session task and command task?

850


What are the modules in Power Center

1430


How you prepared reports for OLAP?

1360


what is the difference between informatica6.1 and infomatica7.1

1929


What is workflow? What are the components of the workflow manager?

894


What is an Integration service in Informatica?

899


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2068