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

I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?

Answer Posted / tina

Use a lookup stage after the file. Do a self-lookup on this
file on empname. When the empname matches, take the empname
and company1 from stream link and company2 from reference
link and map to the target.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1065


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2934


What are the benefits of datastage?

1306


If you want to use the same piece of code in different jobs, how will you achieve it?

1222


what is 'reconsideration error' and how can i respond to this error and how to debug this

2675


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1283


What are some prerequisites for datastage?

1172


What are the features of datastage flow designer?

1104


Why do we use link partitioner and link collector in datastage?

1193


How to read multiple files using a single datastage job if files have the same metadata?

1306


What is the purpose of interprocessor stage in server jobs?

2298


What is the project in datastage?

1171


What is the use of hoursfromtime() function in transformer stage in datastage?

1119


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2877


which r the connectors used in san?

2233