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 do you mean by blocking transformation?

1118

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

---

generate date / time dimension in informatica

1160

---

EXL informatica Questions

1443

---

What is repository manager?

1025

---

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

1284

---

What can we do to improve the performance of informatica aggregator transformation?

1141

---

What are the prerequisite tasks to achieve the session partition?

1295

---

Which files are created during the session rums by informatics server?

1231

---

Explain lookup transformation is active in informatica

1147

---

explan ur project architecture?

2126

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1227

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1842

---

Define Pmrep command?

1110

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2054

---