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)

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

0 Answers  

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

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,

What is the command line function to import and export the ds jobs?

0 Answers  

Can you explain link buffering?

0 Answers  

What is data partitioning?

0 Answers  

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers