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

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

2131

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2891

---

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

1269

---

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

2017

---

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

1773

---

can cubes contain measures ?

2029

---

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

1986

---

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?

1864

---

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

973

---

Is apache nifi an etl tool?

962

---

What is etl process. How many steps etl contains explain with example?

960

---

What is grain of fact?

982

---

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

1994

---

Explain about the data integration suite features?

946

---

What are the different etl testing categories as per their function?

1078

---