suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answer Posted / sanjay
By using the Router transformation we can load half of the
record in target 1 and half in target2.
src-->source qual--->Seq Generator(If
needed)--->router--->targets
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a snowflake schema?
What is Index Caches size?
Can we create multiple integration service on single repository?
How are the sources and targets definitions imported in informatica designer?
What is the benefit of partitioning a session?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What does “tail –f” command do and what is its use as an Informatica admin.
How to elaborate tracing level?
What will be the approach?
What is a filter transformation?
Explain in detail about scd type 1 through mapping.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the status code in stored procedure transformation?
How can we create index after completion of load process?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?