Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 13998 Views
- HCL, HCL BSERV, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / phani kumar
NO.As a Fact table, it contains foreign keys for maintaining
relationships and measures for analyzing the business as
year/half-year/quarter wise.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / kiran
In a factless fact table we can have "textual information".
| Is This Answer Correct ? | 5 Yes | 3 No |
NO, Junk dimension have textual information.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat
Hai phani Kumar,
your answer is wrong
Fact table stores Multi part keys,KPI,Meassures
...
U r saying fcatlessfcat table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sreeni
fact table contains 2 segment dimension keys with measurements
if contains numeric values of what u mesure
| Is This Answer Correct ? | 0 Yes | 0 No |
project Steps,hits, Project level HArd things,Solved methods?
what is the custome stage in datastage? how can we impliment that one? plz tell me
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What is exact difference between Parallel Jobs and server Jobs..
What are stage variables, derivations and constants?
How do u convert the columns to rows in datastage?
What is aggtorec restructure operator?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the difference between validated and compiled in the datastage?
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.
What are datastage sequences?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Teradata 
