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…….
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
What is the need of an ETL tool?
What is a joiner transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the main features of Oracle 8i with context to datawarehouse?
what are the Methods For Creating Reusable Transformations?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the fact table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the restrictions of union transformation?
Explain about cumulative Sum or moving sum?
Explain the informatica workflow?
According to his methodology what all you need before you build a datawarehouse
What if the source is a flat-file?
As union transformation gives UNION ALL output, how you will get the UNION output?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures