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

Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy

now i want o/p like this
1 Srinivasa
2 reddy

could u please help in this

Thanks in advance.

Answer Posted / satya

Make U r source file as SOURCE and LOOKUP Files then
Make lookup on key(in u r question first column),if u find
then concatination of u r source value and u r look up VALU
(Srini:Vasa)

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Terminate Activity

1339


How do you schedule or monitoring the job?

1269


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2078


What are the different plug-ins stages used in your projects?

1126


what is the custome stage in datastage? how can we impliment that one? plz tell me

2411


What are routines in datastage? Enlist various types of routines.

1154


What is merge stage?

1384


What a datastage macro?

1103


Define ds designer?

1328


Highlight the main features of datastage?

1221


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3296


What is the difference between orabulk and bcp stages?

1076


how to delete one row in target dataset

3166


I have a few records just I want to store data in to targets cycling way how?

2415


What are the types of containers in datastage?

1227