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
What is the status code in stored procedure transformation?
what is Active lock explain
Explain informatica architecture - version 8 / 9
What is persistent lookup cache?
What is pmcmd command?
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.
What is enterprise data warehousing?
Clarify the aggregator change?
What is session task and command task?
What are the modules in Power Center
How you prepared reports for OLAP?
what is the difference between informatica6.1 and infomatica7.1
What is workflow? What are the components of the workflow manager?
What is an Integration service in Informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?