Give example for FACTLESS FACT TABLE in real-time scenario.
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 |
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How to reverse the string using SQL?
Define Merge?
if ename='subbu' while running job the job should be abort how come?
how to load meta data
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
Display all files which have size more 3KB in given directory/folder.
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
What is audit table?
How many types of hash files are there?