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';

Define Dynamic push down optmization?

2290

---

What are various etl tools in the market?

995

---

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3753

---

Can there be sub steps of etl steps?

1011

---

what are the facilities provided by data warehouse to analytical users?

2072

---

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?

2880

---

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

973

---

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3012

---

Can we create Hierarchies in generic datasources?

2371

---

Compare ETL & Manual development?

938

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2054

---

Explain do we need an etl tool?

1006

---

explain the methodology of Data Warehousing?(Polaries)

2012

---

what is the difference between cubes and package in cognos

4941

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2261

---