Answer / ashish goel

Data warehouse is generally designed for analyzing the
business operations but not to run the business operations.

Answer / vas.chiky

Having separate OLAP DWH database for analysis, increases
the performance of reports.

even during backup or crash period of oltp, OLAP database
will not get affected.

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

what is mapping performence?

2 Answers   Cap Gemini,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

how will you get 21 to 30 record from 50 records?

6 Answers  

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

What is an expression transformation?

0 Answers  

---