Answer Posted / satya

Hi All,

If anyone have informatica dumps for developer certification, please forward to my mail. My email id is 'dt.satyam@gmail.com'

Thanks & Regards
Satya

What is data modeling and data mining?

980

---

Explain etl mapping sheets?

1082

---

What is virtual Data Warehousing?

982

---

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.

1958

---

flat filevalidation in informatica

2157

---

Difference between flat files and relational sources?

2245

---

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

2428

---

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?

1865

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2177

---

What is tracing level and what are the types?

960

---

what are the concerns of OLTP and DSS systems?

1962

---

where is the cache (lookup, index) created and how can you see it.

2017

---

What is meant by incremental load?

1097

---

What is the difference between round-robin partitioning and hash partitioning?

973

---

what is an ETL or ETT? And what are the different types?

7497

---