Answer Posted / kumar

Hi Mr.Manthiramoorthy , thanks for valuable information. 


Could you plz tell generally how many dimensions and fact table are there in sales DWH and how frequently we load them(daily or weekly or ....).
You can also mail to 'myetlblog@gmail.com ' . Cheers...

 

Thank you.
Regards,
Kuamr.

Difference between Target-based loading and constraint-based loading?

994

---

How do you handle two sessions in Informatica

1149

---

What are the limitations of joiner transformation?

1102

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7180

---

Explain the etl program with few examples.

1046

---

What is InformaticaPowerCenter?

1127

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2117

---

What is an Integration service in Informatica?

1128

---

What is aggregate cache in aggregator transformation?

1139

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2132

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

---

What are the mapping parameters and mapping variables?

1197

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1062

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2035

---