Answer / gopal

Collection of multiple fact tables surrounded by dimension is called galaxy or multistar or fact consultaion Schema.

Answer / b.indu

A combination of star schema and snow flake star schema is known as galaxy schema

what is sql override?what is the use of it?

4 Answers   Sonata,

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

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,

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

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,

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

What do you mean by blocking transformation?

0 Answers  

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---