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.

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

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,

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

0 Answers   Wipro,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---

What are the types of containers?

0 Answers  

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---