how can we load starting with 11th record of a table from
source to target
Answer Posted / krish
take expression in exp take variable port(v1.......v1+1)and
take output port(in that give v1)send this o/p port to
router give the condition as v1>11.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are different types of transformations available in informatica?
What are the modules in Power Center
While migrating the data from one environment to another environment how would you manage the connections?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What can we do to improve the performance of informatica aggregator transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
Why do we need informatica?
What is rank transformation in informatica
What do think which one is the better joiner or look up?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
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