Answer / ganesh kumar

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

TRY THIS QUERY IT WILL WORKS CORRECTLY.

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

How to differentiate between the active and passive transformations?

0 Answers  

---

What is rank transformation?

0 Answers  

---

What is informatica powercenter repository?

0 Answers  

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---