Answer / nagaraju bhatraju

There is a lot of diffrence between informatica an Ab Initio

In Ab Initio we r using 3 parllalisim

but Informatica using 1 parllalisim

In Ab Initio no scheduling option we can scheduled manully
or pl/sql script

but informatica contains 4 scheduling options

Ab Inition contains co-operating system

but informatica is not

Ramp time is very quickly in Ab Initio campare than
Informatica

Ab Initio is userfriendly than Informatica

what is the predefined port in dynamic lookup

2 Answers  

---

what is unique constraint error ?

2 Answers   TCS,

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

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,

---

Why update strategy and union transformations are active?

0 Answers  

---

What is Data Caches size?

0 Answers   Informatica,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

What is batch and describe about types of batches?

2 Answers  

---

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---