Answer Posted / shyam

You can fire the query based on the timestamp.If the
loading happened today you can give the condition like--
>Sel * from table where date > 'yesterday's_date';

explain the methodology of Data Warehousing?(Polaries)

1934

---

What are the modules in Power Mart?

893

---

What do you understand by active and passive transformations?

880

---

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

2369

---

What is meant by incremental load?

1015

---

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

1133

---

what is the use of server?

2128

---

dimension object created in oracle can be imported in designer?how?

2902

---

What are various etl tools in the market?

938

---

how many maximum session supports to multiload in teradata ??

2040

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2494

---

what are the concerns of OLTP and DSS systems?

1898

---

what are the production issues in datastage?

10310

---

what is pmrep command?

2364

---

What is a mapping?

935

---