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?
- 9 Answers
- 10727 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
src--->Exp--->Seq--->Rtr---->tgt
in sequence generator we will get a key and in rtr we will
mention condition
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is the size of u r source(like file or table)?
What is blocking transformation?
How does a rank transform differ from aggregator transform functions max and min?
What does refresh system mean, and what are its distinctive choice?
Difference between Target-based loading and constraint-based loading?
How to delete duplicate row using informatica?
Explain pmcmd command usage in informatica
How to join three sources using joiner? Explain though mapping flow.
Clarify the utilization of aggregator cache record?
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 are the advantages of using informatica as an etl tool over teradata?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Can you generate sequence numbers without using the sequence generator transformation?
What is pmcmd command?
what is the difference between informatica6.1 and infomatica7.1
