Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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…….

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


Please Help Members By Posting Answers For Below Questions

What is the need of an ETL tool?

1108


What is a joiner transformation?

997


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.

2308


What are the main features of Oracle 8i with context to datawarehouse?

2115


what are the Methods For Creating Reusable Transformations?

1183


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?

2191


What is the fact table?

1076


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.

2282


What are the restrictions of union transformation?

1044


Explain about cumulative Sum or moving sum?

1046


Explain the informatica workflow?

1074


According to his methodology what all you need before you build a datawarehouse

1761


What if the source is a flat-file?

1119


As union transformation gives UNION ALL output, how you will get the UNION output?

1110


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2402