In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

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,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

What is the difference between odbc and drs stage?

0 Answers  

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

Explain how a source file is populated?

0 Answers  

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

how do u capture duplicates through sort & transformer

4 Answers  

---

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---