Interested to Buy Any Domain ? << Click Here >> for more details...
My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
- 7 Answers
- 10278 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / firdaus
src-->exp1-->target1
src-->exp2-->target2
In exp1 drag i/p port,then take o/p port
0/p=i/p||0
In exp2 drag i/p port,then take o/p port
0/p=i/p||1
thn link o/p ports of exp1 & exp2 to target1 & target2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
In warehouses how many schemas are there?
What is flashback table ? Advance thanks
what is degenerated dimension?
How to call shell scripts from informatica?
scenario where i can use only concurrent execution of workflow.
Why update strategy and union transformations are active?
What do you mean by blocking transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we override a native sql query within informatica?
What is fact table? Explain the different kinds of facts.
What are data-driven sessions?
Can we create a Integration service without a Repository service and vice versa?
