Answer / bhargavi

Facts are numeric values (or) daily transactions done to any
business.

Dimensions are detail information about business

E.g.,: cust no,customer name,addr...

Answer / mohammadsadiq

Facts in Banking

Account no


Dimensions in Banking

Branch
Amount

Answer / subhash

FACT Table:(Daily transaction details)
Transaction_Details

Dimension Tables:(Which have static data)

Customer_details
Account_Details

DATE & TIME

Answer / saikumar

Fact Table: it contains all the transnational Data of the customer 
eg: deposited date,withdrawn date etc...


Dimensional Table: it contains non-transnational Data of the customer

eg:  c.city,c.loc,c.cname etc.

How do you get log info into a file?

1 Answers  

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---

How can we achive parallelism

1 Answers   CTS,

---