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 / satish

Hi

First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable 

Str( DSLink2.column_2, DSLink2.Column_1).

Drag and drop the stage variable to required output column,
finally load the data in target. 

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247


Differentiate between validated and Compiled in the Datastage?

1357


What are orabulk and bcp stages?

1165


To see hidden files in LINIX?

1589


What is active and passive stage?

1469


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2103


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2267


What are the various kinds of containers available in datastage?

1100


Explain ibm infosphere information server and highlight its main features?

1140


what is the use of materialized view?

1639


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1922


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2416


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

1154


Can you explain link buffering?

1223


Name the third party tools that can be used in datastage?

1139