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...

In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?

Answer Posted / jyothi

source s1 contains input data (A B C)
take 3 flows in mapping
create 3 instances for the target.
ex: target is T .Instances for T are t1 t2 t3
t1
/
/
s1---exp---t2
\
\
t3

load the data into targets using target load strategy
then we will get output as above

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of Power Center 5.0?

1698


What is rank transformation in informatica

1107


What does command task mean?

1062


Differentiate between source qualifier and filter transformation?

1508


Separate from a database, an information bazaar, and an information stockroom?

1010


Suppose we do not group by on any ports of the aggregator what will be the output?

981


What is a transaction control transformation?

1142


Under what condition selecting sorted input in aggregator may fail the session?

1056


How we can use union transformation?

988


What is a filter transformation?

987


What are data-driven sessions?

1142


Why update strategy and union transformations are active?

988


State the limitations where we cannot use joiner in the mapping pipeline?

993


How you can differentiate between connected lookup and unconnected lookup?

1005


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1505