Answer / ganesh kumar

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

TRY THIS QUERY IT WILL WORKS CORRECTLY.

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Briefly explain the aggregator transformation?

0 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

---

What is IQD file?

1 Answers  

---

How to do unit testing in informatica?

0 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

How can we use batches?

0 Answers  

---