Answer / ganesh kumar

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

TRY THIS QUERY IT WILL WORKS CORRECTLY.

Repository user profiles

0 Answers  

---

How many ways you create ports?

1 Answers  

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

what is the predefined port in dynamic lookup

2 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---