Answer / ajay konidena

we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB

Answer / chinni

If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

can we generate reports in informatica ? How?

3 Answers  

---

Where do we use mapping variables in informatica?

0 Answers  

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

what is data driven?

1 Answers  

---

What is active and passive transformation?

10 Answers  

---