Answer / d

Str('0',6-Len(string)): string

Answer / venkata ramana

Input Seq file:

CodeName
AB1
Aim2
Abnv5
1An8bx

Note: Column(CodeName) lenth is 6

Seq-->Transformar--DataSet

Trasformar:-

In Derivation cell:

Str('0',6 - Len(DSLink3.CodeName)):DSLink3.CodeName

Out put Dataset:-

000AB1
00Aim2
0Abnv5
1An8bx

Answer / subbuchamala

In the Output Column Derivation of Transformer Stage:

1. Way:
Str('0',6-Len(string)): Input_Col--->Output_Col

2. Way:
right("000000" : Input_Col),6) --->Output_Col

3. Way:
Right(Str("0",6) : Input_Col),6) --->Output_Col
Right(Str("0",3) : Input_Col),6) --->Output_Col

Answer / reddymkl.dwh

right(str("0",3):source_data,3)

Answer / deepak patel

Hey,
You can simply draw output link to next outfile and set column name Datatype varchar and size to 6 and in output file you will get desired output.

Answer / prasu

right(str(0,3)':'source data),6)

How we can convert rows to columns in datastage?

4 Answers   IBM,

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

how to define satge variables in transformer stage

2 Answers  

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

0 Answers  

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

What is process model?

0 Answers  

what is set mapping in datastage??

2 Answers   ADP,

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

how does work server jobs?

1 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,

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

6 Answers   CTS,