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
- 3103 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 |
Separate from an archive server and a powerhouse?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
How can yoU improve session performance in aggregator transformation?
How would you copy the content of one repository to another repository?
How do you load alternate records into different tables through mapping flow?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
how to create a sample mapping for dynamic lookup transformation
Can we use the mapping parameters or variables created in one mapping into another mapping?
what is degenerated dimension table with scenario
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
How many repositories can we create in Informatica?
What are the session parameters?
Teradata 
