Answer Posted / lajpat kurdiya

SELECT SUBSTR(12345,LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH(12345);


SELECT SUBSTR('12345',LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH('12345');

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1461

---

How to Remove Duplicate using SQL?

1424

---

What are the components of ascential data stage?

1241

---

what is flow of project?

2056

---

What are the different common services in datastage?

1337

---

Explain the situation where you have applied SCD in your project?

2087

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2535

---

What is quality stage?

1044

---

What is the difference between operational data stage (ods) and data warehouse?

1294

---

What is the difference between server job and parallel jobs?

1200

---

Differentiate between data file and descriptor file?

1107

---

how to sort two columns in single job in datastage.

2957

---

On which interface you will be working as a developer?

1106

---

Can you highlight the main features of ibm infosphere information server?

1125

---

What are some prerequisites for datastage?

1169

---