Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 3479 Views
- Franklin Templeton, I also Faced
- E-Mail Answers
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 decode in informatica?
What is powercenter on grid?
Write the unconnected lookup syntax and how to return more than one column.
Explain load alternative records / rows into multiple targets - informatica
Do you find any difficulty while working with flat files as source and target?
how to create user defined function (udf) in informatica
Explain pmcmd command usage in informatica
What is a sequence generator transformation?
What is the use of code page?
what are 3 tech challenges/ common issues you face?
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 differs when we choose the sorted input for aggregator transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the Process to creating lookup transformation in informatica
Define joiner transformation?
