Answer Posted / rams

Using pivot stage


ex:-


name,ph1,ph2
ramu,9849,9948
raja,9987,9967
touch,9898,0909


in pivoi stage go to output>- columns


columnname derivation

name
phone PH1,PH2

TO GOT THE RESULT IS


o/p:-

name phone
ramu,9849
ramu 9948
raja,9987
raja,9967
touch,9898
touch,0909

Define Routines and their types?

1098

---

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

1163

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2156

---

What are transforms and what is the differenece between routines and transforms?

1003

---

what is the difference between == and eq in UNIX shell scripting?

1422

---

Describe stream connector?

1246

---

Why do we use exception activity in Datastage?

1230

---

How a server job can be converted to a parallel job?

1044

---

What are the components of datastage?

1066

---

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.

3266

---

What are stage variables and constants?

1098

---

what is use of SDR function?

5128

---

Define oconv () and iconv () functions in datastage?

1344

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2386

---

How can we improve performance of data stage jobs?

968

---