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
- 3385 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 the use of code page?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the tasks that can be performed using sq?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Tell me about Propagate functions in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the procedure for creating independent data marts from informatica 7.1?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain the etl program with few examples.
Could you explain what is enterprise data warehouse?
What could be the possible resons of locks by user?
generate date / time dimension in informatica
Why union transformation is an active transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
