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 happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

what is confirmed fact?

2 Answers  

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---