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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / a

Answers were Sorted based on User's Feedback



i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc..

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

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc..

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

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc..

Answer / naresh

Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable 
finally load the data in target.

Is This Answer Correct ?    2 Yes 1 No

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc..

Answer / geetha

use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Data Stage Interview Questions

what is time dimension? and how to populate time demension

2 Answers   TCS,

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

What is data partitioning?

0 Answers  

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

What is the difference between informatica and datastage?

0 Answers  

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

What is the difference between an operational datastage and a data warehouse?

0 Answers  

What are the stages in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories