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

What are the benefits of datastage?

1301


how can we create rank using datastage?what is the meaning of rank?

8856


What is datastage engine?

1225


What are the types of hashed files in data stage

1146


Explain ibm infosphere information server and highlight its main features?

1140


How do y read Sequential file from job control?

16078


What are the various kinds of containers available in datastage?

1100


How complex jobs are implemented in datstage to improve performance?

1095


Which warehouse using in your datawarehouse

2233


AGGREGATOR default datatype

1522


What is a folder? Difference types of stages?

1240


What are the repository tables in datastage?

1350


Describe routines in datastage? Enlist various types of routines.

1054


What are the functionalities of link partitioner?

1067


What are system variables and sequencers in datastage

1182