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
- 2777 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 union transformation in informatica?
Can you use flat files in Mapplets.
Differentiate between joiner and lookup transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Enlist the tasks for which source qualifier transformation is used.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is meant by pre and post session shell command?
Explain in detail about scd type 1 through mapping.
Briefly define reusable transformation?
What are the differences between a connected lookup and unconnected lookup?
What is different between the data warehouse and data mart?
Explain the pipeline partition with real time example?
What are the main issues while working with flat files as source and as targets ?
what is the size of u r source(like file or table)?
