Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

---

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

---

how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  

---

In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

What is etl process? How many steps etl contains?

0 Answers  

---

how to connect to a flatfile through ftp in informatica

1 Answers   TCS,

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

Difference between flat files and relational sources?

0 Answers  

---

What is ROWID explain ?

2 Answers   Wipro,

---