Answer / pushparao

DSS stands for decision support system.
it can used to implement effective decision making to
understood middle level management for OLAP systems.
that means reports are generated effectively in two and
multidimensional.

Answer / pranu

DSS database is optimized for running data queries that do not change the data. Since OLAP tools are used for analyzing data by running analytical queries, it is best to use DSS database

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

Describe expression transformation?

0 Answers  

---

What are the different caches used in informatica?

3 Answers   UST,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---