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

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

1051

---

how to load dimension table and fact table. plz tell me the steps.

2039

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1014

---

How to extract sap data using informatica?

987

---

Difference between Target-based loading and constraint-based loading?

946

---

How to generate sequence numbers using expression transformation?

1029

---

Is it possible to use a client with different version than that of its Informatica server?

1077

---

What differs when we choose the sorted input for aggregator transformation?

969

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

Where are the source flat files kept before running the session?

1012

---

How to update or delete the rows in a target, which do not have key fields?

1121

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2353

---

What are the tasks that can be performed using sq?

1026

---

What does reusable transformation mean?

1073

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2210

---