What are the differences between oltp and olap?

0 Answers  

---

what is confirmed dimension?

6 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

What is the use of transformation?

0 Answers  

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

What are the databases that informatica can connect to windows?

0 Answers  

---