Answer / rr

select to_number('5672345') from dual

Answer / moorthy g

Hi Jey,

Please see the below procedures (integer to varchar or char).
SQL> CREATE TABLE DEPT1 AS SELECT *FROM DEPT
SQL> Truncate table dept1;
SQL> alter table dept1 modify(deptno varchar2(20));
SQL>insert into dept1 select *from dept;
SQL> SELECT *FROM DEPT1

Note:
1. If you want to modify in information please the load type
truncate load or not. (May it will be truncate load only)

Best Regards,
Moorthy. G

Answer / 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;
***********************************************

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

---

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

Can we make worklet inside worklet?

1 Answers  

---

How to update source definition?

0 Answers  

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

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

2 Answers   CTS,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---