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
- 3494 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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the difference between informatics 7x and 8x and what is latest version?
What is a pre-defined event and user-defined event?
What is a repository manager?
How to create a non-reusable instance of reusable transformations?
what is unit testing?tell me proceedure
Differentiate between router and filter transformation?
How can we handle two sessions in informatica?
How to improve the performance of a session using sorter transformation?
Differentiate between joiner and lookup transformation?
Enterprise data warehouse your projects phase by phase explain?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of schemas we have in data warehouse.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the types of caches in lookup? Explain them.
