Answer / isha

Ralph Kimball's dimensional design approach (the bottom-up design): The data marts facilitating reports and analysis are created first; these are then combined together to create a broad data warehouse. Inmon defines data warehouse as a centralized repository for the entire enterprise.

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

How do you load only null records into target?

0 Answers  

---

What is a snowflake schema?

0 Answers  

---

in static and dynamic which one is better

2 Answers  

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

---

How many joins in Informatica

5 Answers   CSC,

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---