Interested to Buy Any Domain ? << Click Here >> for more details...
Give example for FACTLESS FACT TABLE in real-time scenario.
- 4 Answers
- 19032 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / viswa
Factless table means only the key available in the Fact
there is no measures available.
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / ram
for ex:%discount in retail project
studant Attendance
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / usha
FACTLESS FACT TABLE means a FACT table with out measure.
ex:student registration details
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / satyam
genarelly fact table contains keyvalues and mesures products like that,fact less means it contains measures only so example in real time %discount,student monthly %of attendence like that ok,i think its a right once according my knowledge
| Is This Answer Correct ? | 7 Yes | 5 No |
What could be a data source system?
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
What are the features of datastage flow designer?
what are fact tables and dimension tables? give example assuming one table.
if ename='subbu' while running job the job should be abort how come?
Define APT_CONFIG in Datastage?
what is A Datastage?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How to convert alpha Numeric values to alpha using functions?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the project in datastage?
Teradata 
