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
- 3141 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
Reusable transformation and shortcut differences
Why do we need informatica?
what is size of u r database?
What are the different components of powercenter?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to join three sources using joiner? Explain though mapping flow.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Which development components of informatica have the highest usage?
What is expression transformation?
What is data transformation manager process?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is diff b/t sorter t/r and agg have the option sorter property...
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How do we call shell scripts from informatica?
