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?
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 |
What happens when a session fails and you click on recover?
During the running session, output files are created by informatica server. Enlist few of them.
Explain how many types of dimensions are available in informatica?
what is data driven?
scd methodology?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
How the Informatica Server reads perameter file?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Explain pushdown optimization and types in informatica
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .