Answer / ganesh kumar

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

TRY THIS QUERY IT WILL WORKS CORRECTLY.

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---

What is Code Page Compatibility?

1 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---