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 ')

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---

How to perform incremental load in datastage?

0 Answers  

---

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---