Answer Posted / param

Hi all,
Kindly forward the exam content to parameshwaran@gmail.com.

Thanks

Give the benefits of data integration suite?

955

---

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.

2082

---

what is dynamic insert?

2249

---

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?

1914

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

1021

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1254

---

Explain the key challenges that you face while performing etl testing.

1056

---

how does the server recongnise the source and target databases.Elaborate on this

2739

---

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

2661

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2040

---

How etl testing is different from database testing?

1116

---

how do u extract data from different data sources explain with an example?

2327

---

What are the ETL Testing Operations?

1096

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1836

---

how to connect to a flatfile through ftp in informatica

14377

---