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

How to clean the datastage repository?

1069

---

explain about citrix scheduling tool in datastage

2379

---

How to read the length of word in unix?

1310

---

Difference between data warehousing and olap?

1042

---

What are stage variables?

1138

---

Highlight the main features of datastage?

1089

---

On which Dimension Table you implemented SCD Type in your Project

1969

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2757

---

Explain entity, attribute and relationship in datastage?

1043

---

CHANGE CAPTURE

1257

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2002

---

How do you start developing a datastage project?

1057

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3211

---

Explain how a source file is populated?

1312

---

What are routines in datastage? Enlist various types of routines.

1047

---