Answer Posted / ankit kansal

OLTP systems are designed to handle events (Inserts,Update,Delete) frequently so its better to keep your database more normalized form as selection is not as frequent where as in case of
OLAP systems are designed purely for analysis or to find out trends using historical data so, to achieve this kind of functionality a data warehouse are designed more de-normalized where query(selection) is much faster.
http://deepinopensource.blogspot.in/

what is a worklet?

1029

---

What is virtual Data Warehousing?

1029

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1861

---

what is the use of structures?how many nodes can u create in a structure?

2284

---

What is initial load and what is full load?

1047

---

What are materialized views & where do we use them?

1063

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1942

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2008

---

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

---

Is apache nifi an etl tool?

1013

---

what is Forward,Reverse and Re_engineering?

2306

---

What are the etl testing operations includes?

1151

---

what happens if the info.server doesn't find the session parameter in the parameter file?

1986

---

what is data modeling?

2352

---

Define Dynamic push down optmization?

2343

---