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.

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

---

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

2 Answers   Accenture,

---

major difference between normal loading and bulk loading?

6 Answers  

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

---

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

4 Answers   IBM,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---