Answer Posted / rajesh

ANS: We can put textual information but not useful, actually
in FACT table, in contains numeric value for calculating
measurement like sales, profit/loss, revenue, date/time,
production, stock etc. in Fact table, it contains foreign
keys for maintaining relationships and measures for
analyzing the business as week/ month/quarter/year etc.

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2048

---

What is the flow of loading data into fact & dimensional tables?

1064

---

What is job control?

1119

---

How do you import and export the datastage jobs?

1161

---

How you can fix the truncated data error in datastage?

1794

---

What are the various kinds of the hash file?

1152

---

What is size of a transaction and an array means in a datastage?

1315

---

table actions available in oracle connector?

1613

---

What is a datastage job?

1013

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

---

Define ds designer?

1285

---

How to implement complex jobs in data stage?

1113

---

State the difference between an operational datastage and a data warehouse?

1134

---

What are transforms and what is the differenece between routines and transforms?

1066

---