Answer / gurpreet

Decision Support System

Helps the management to take decisions using raw data, documents, reports, business models.

Usually, the DSS has the inventories of the current assets of the company in form of legacy systems, relational DBs, data warehouses, etc.

It can help project the revenue and sales.

Answer / sunil

dss is designed to support decision making process.
data is non volatile,histirical data,summary data.
integrated database,subjectoriented database.

Answer / prathima

dss stands for decision support system,dwh supports dss
process.and its for making decisions for bussiness analysis
purpose for manageral access.

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

What is the difference between router and filter?

0 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

How to differentiate between the active and passive transformations?

0 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---