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 input like this

Column 1 ,column 2
3,a
4,b
5.c

i want output 
aaa
bbbb
ccccc

Ple help any one?

Answer Posted / subbuchamala

Ex:
Str( "a", 3)---->aaa
Str( "b", 4)---->bbbb

Solution:
use below transformer Logic in Output Col Derivation:

Str(DSLink2.col2, DSLink2.Col1)--->Output_Col(Output Column)

Output:

Output_Col
aaa
bbbb
ccccc

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between validated and Compiled in the Datastage?

1282


Define Merge?

1320


how to implement scd2 in datastage 7.5 with lookup stage

5606


What is meta stage?

1183


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

2865


Where the datastage stored his repository?

1089


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463


What is aggtorec restructure operator?

1453


Differentiate between odbc and drs stage?

1050


What steps should be taken to improve Datastage jobs?

1074


describe the Steps to confiure a Qlogic switch

2383


What are the different types of lookups in datastage?

1054


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

1027


What is difference between join, merge and lookup stage?

1099


What are the different common services in datastage?

1287