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

Is stop and abort are same in informatica?

954

---

Write the unconnected lookup syntax and how to return more than one column.

1063

---

What is resilience time?

1062

---

What is Index Caches size?

1061

---

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

1019

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1127

---

where to store informatica rejected data? How to extract the informatica rejected data?

962

---

How can we delete duplicate rows from flat files?

1173

---

Differentiate between joiner and lookup transformation?

1058

---

What are the measure objects?

1126

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2695

---

Enlist the tasks for which source qualifier transformation is used.

994

---

Under which circumstances, informatica server creates reject files?

1034

---

How identifying bottlenecks in various components of informatica and resolving them?

1065

---

Explain in detail about scd type 1 through mapping.

1305

---