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
- 3487 Views
- Franklin Templeton, I also Faced
- E-Mail Answers
Answer / 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 |
Explain in detail about scd type 1 through mapping.
I have a flat file, want to reverse the contents of the flat file
what is row level and column level indicator?
What are the static cache and dynamic cache in informatica?
How do you implement unconn. Stored proc. In a mapping?
how do u use sequence created in oracle in informatica? Explain with an simple example
Define mapping and session?
what is the flow?
What is meant by target load plan?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is mapping performence?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Teradata 
