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 is the different lookup cache(s)?

1081

---

In which transformation you cannot drag ports into it?

1311

---

Design a mapping to load a target table with the following values from the above source?

1336

---

How can we delete duplicate rows from flat files?

1212

---

What is a mapplet/worklet in informatica?

1183

---

What is a connected transformation?

1112

---

differences between service based and product based?

2007

---

What are active and passive transformations?

1079

---

How many types of sessions are there in informatica.please explain them?

1159

---

What is olap (on-line analytical processing?

1063

---

What are the various types of transformation?

1171

---

What are the components of workflow manager?

1085

---

What is mapping debugger?

1004

---

How do you load unique records into one target table and duplicate records into a different target table?

1221

---

Explain what are the different types of transformation available in informatica.

1132

---