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

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

what are surrogate keys?

5 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

---