Answer / akila

Create 3 stage variables to split the name into three and
then concatenate

SV1 = Field(NAME," ",1)
SV2 = Field(NAME," ",2)
SV3 = Field(NAME," ",3)

Then concatenate in the column derivation as sv1:sv2:" ":sv3

Answer / hussy

I am sowwie akila. tat was the correct answer mistakenly I
have clicked on the other option. hope u dont mind

Answer / vaibhav

Hi Akila,

What if input name comes as Ajay Rathore... Surname should be differentiated with space and middle name should be concatenated with first name...then this solution might be wrong...

Answer / ambi

select Replace('Reddyvaraprasad','vara','vara ')

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

---

what are the types of nodes

4 Answers   HCL, 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,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

---

What is lookup table?

5 Answers  

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

---

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---

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

5 Answers  

---

Explain how a source file is populated?

0 Answers  

---