Give example for FACTLESS FACT TABLE in real-time scenario.
- 4 Answers
- 17294 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 |
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How to transfer file from one system to another system in UNIX?which command to be use?
In Datastage, how you can fix the truncated data error?
what is snow flack schema?
when we will use connected Lookup & Unconnected Lookup
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
how can i abort the job if i get more than 100 errors in job log?
How can we do null handling in sequential files?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
Nls stands for what in datastage?
Define ds designer?
How can we run same job in 1 day 2 times
Teradata 
