Answer / jaspreet banga

There are lots of answer for this question but i will give
you simple one, 'JUST CONSIDER A PEN, NOW SALES OF THAT PEN
IS FACT I.E., A METRICS , A MEASURABLE QUANTITY,.
what is the name of brand, its date of manufac,expiry
date, ie., DESCRIBING FEATURES are different DIMENSIONS,
i.e., SOMETHING WHICH DESCRIBES THE PEN.--hence fact tables
contains 2 things the" foreign keys from differnt dimension
table and the METRICS " while all describing features are
available in the dimenasion table. hope this clears your
concept..

Answer / boopalan venugopal

THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

explan ur project architecture?

0 Answers   TCS,

---

what is row level and column level indicator?

1 Answers   TCS,

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

what is polling?

1 Answers   Informatica,

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

How to delete duplicate records in a flat file source?

2 Answers  

---