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 to create a doccument in datastage?

1 Answers   Cap Gemini,

Difference between in process and inter process?

0 Answers  

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

what are the different type of errors in datastage?

2 Answers   Wipro,

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

Explain how a source file is populated?

0 Answers  

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,