Answer / anchalthakran

Source file Input: abcdefghijklmnopqrs

Solution:- seq file---> transformer stage---> seq file

under function-->string-->convert function will give desired output.

Convert("j" , "z" , "abcdefghijklmnopqrs" )

Target file Output: abcdefghizklmnopqrs

Answer / trupti

InputField = "abcdefghijklmnopqrs"

step by step we can use transformer functions as,

1. left(InputField,10) ==> OP will be 'abcdefghij'

2. Use above output in
right (abcdefghij,1)= 'J'

The final derivation will be like below,

Convert(right(left(InputField,10),1),'Z',Inputfield)

Output :- abcdefghiZklmnopqrs

Name the different types of Lookups in Datastage?

0 Answers  

---

AGGREGATOR default datatype

0 Answers   CTS,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

---

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 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  

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---

How to reverse the string using unix?

0 Answers   CTS,

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---