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
- 3399 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 source qualifier transformation in informatica?
What is informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can anyone tell me the new features in Informatica 9 Version?
What is rank transform?
What is a snowflake schema?
How to join three sources using joiner?
What is lookup transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Where do we use mapping variables in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
What is rank index in rank transformation?
Explain your project of banking domian.
can u give example for factless fact table
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
