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 did you reconcile source with target?

2 Answers   HP,

how many types of remove the duplicate records?

3 Answers   Caterpillar,

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

What is a delta record? How you will read it?

0 Answers   EDS,

How many areas for files does datastage have?

0 Answers  

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

what is use of SDR function?

0 Answers   CGI,

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

5 Answers  

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

Is the value of staging variable stored temporarily or permanently?

0 Answers  

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

Name the command line functions to import and export the DS jobs?

0 Answers