Answer / srikanth

Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.

Answer / kathyayini

fact table is the collection of foriegn keys corresponding
primary keys in the dimention tables


dimention table is the table which contains primary key and
will give detail informati1on about perticular instance

Answer / ramesh

A Fact table is a table that contains the measures of
intersert.
A dimensional table is a collection of hierarchies and
categories along which the user can drill down and drill
up. it contains only the textual attributes.

Difference between sequential file and data set?

0 Answers  

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

What is a datastage job?

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,

---

Can you highlight the main features of ibm infosphere information server?

0 Answers  

---

What are the functionalities of link partitioner and link collector?

0 Answers  

---

what is factless fact table?

3 Answers   IBM,

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---