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..

What is substr in informatica?

0 Answers  

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

What are the different tools in workflow manager?

1 Answers  

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

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,

---

Can we run session without using workflows?

5 Answers   TCS,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

What is Cognos script editor?

0 Answers   Cognizant,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

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

2 Answers   Accenture,

---