Answer / Nripendra Chandra Verma

A Database is an organized collection of data that stores structured information and provides a means to manipulate it. It's designed for transaction processing and real-time access. A Data Warehouse, on the other hand, is a large storage repository that provides historical and summary data for analysis and reporting purposes. It's optimized for querying and analyzing large amounts of data.

tell me the rules and responsblites in our project(my project is development)

1 Answers  

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

Can you use flat files in Mapplets.

1 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

To import the flat file definition into the designer where should the flat file be placed?

1 Answers   Informatica,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

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

2 Answers   Accenture,

---

Describe expression transformation?

1 Answers  

---