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 / narayana kota

Hi

you can do this job using Pivot Stage convert these rows in
Columns by specify the column name in pivot stage as
first_column ,second_column and third_column and using
tranformer stage concatante first_column and second_column
using stage variables and pass to target.


if any method is there plz let me known
Regards
Narayana Kota
pnarayana12@gmail.com

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all the types of jobs you developed?

1186


Differentiate between datastage and informatica?

1195


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2504


What are the some differences between 7.x and 8.x version of datastage?

1267


Which commands are used to import and export the datastage jobs?

1419


Explain usage analysis in datastage?

1181


What are the important features of datastage?

1137


describe the Steps to confiure a Qlogic switch

2391


What are the various kinds of the hash file?

1154


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

2819


Define project in datastage?

1104


State the difference between an operational datastage and a data warehouse?

1141


What is the method of removing duplicates, without the remove duplicate stage?

1034


What is difference between symmetric multiprocessing and massive parallel processing?

1154


Describe stream connector?

1313