Answer Posted / ankit kansal

First of all Oracle supports implicit conversion between char to number if the specified text is of number type only.
*********************************************
Lets say sql>select '111'+1 as ans from dual;
ans
---
112
*********************************************
Here, 112 is the output you received it does not matter '112' as string.
But For precautions you can write your query as
***********************************************
sql>select to_number(trim('111'))+1 from dual;
***********************************************

What does “tail –f” command do and what is its use as an Informatica admin.

830

---

What is InformaticaPowerCenter?

879

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1825

---

Why update strategy and union transformations are active? Explain with examples.

924

---

Can u generate reports in Informatica?

816

---

---

Explain lookup transformation source types in informatica

867

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2116

---

How would you join a node to the already existing domain?

885

---

What is an expression transformation?

786

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1874

---

What is the function of union transformation?

812

---

r u done any partitions in ur project?

1554

---

What is persistent lookup cache?

768

---

Difference between Data and Index Caches?

859

---

Explain the code page compatibility?

816

---