can a fact table contains textual information
Answer Posted / reddymkl.dwh
NO, Junk dimension have textual information.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to RD using transformer?
What are the types of views in datastage director?
what is flow of project?
What is the difference between validated and compiled in the datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the processing stages?
What is the difference between server job and parallel jobs?
How a source file is populated?
What are the main features of datastage?
What are orabulk and bcp stages?
Describe the main features of datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you define merge?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?