Answer Posted / parvar

The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data

what is the difference steps for data modeling?

2049

---

Can u access a repository created in previous version of Informatica?

1804

---

What is partitioning? Explain about round-robin, hash partitioning.

896

---

What is partitioning? Explain different types of partitioning?

1159

---

What is virtual Data Warehousing?

925

---

What is a lookup table in etl?

1107

---

What are snapshots?

931

---

how would u estimate the size of Lookup transform data and index cache?

2077

---

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?

1821

---

what do u do when DB time takes more?in sap bi

2141

---

tell me few points when u become TL

2455

---

Is hadoop a etl tool?

882

---

Compare ETL & Manual development?

897

---

How etl testing is different from database testing?

966

---

Explain do we need an etl tool?

948

---