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

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1025

---

What are the uses of etl tools?

641

---

What is a grid in Informatica?

605

---

What are the reusable transformations?

691

---

Differentiate between a repository server and a powerhouse?

571

---

---

Explain sessions. Explain how batches are used to combine executions?

585

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1529

---

What are the different types of repositories created using informatica?

651

---

What does refresh system mean, and what are its distinctive choice?

564

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1575

---

How to generate sequence numbers without using the sequence generator transformation?

637

---

what is mean by complex business rule ?

1713

---

r u done any partitions in ur project?

1397

---

What are the performance considerations when working with aggregator transformation?

672

---

Enlist the advantages of informatica.

622

---