what is factless fact table?
Answers were Sorted based on User's Feedback
Answer / madhusudhan reddy.d
A fact table without any facts is known as factless fact
table. Always a Fact should be a Numeric value but every
numeric value need not be a fact.
| Is This Answer Correct ? | 13 Yes | 0 No |
In merge stage can we update the values?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
Describe link sort?
how to get the unique records on multiple columns by using sequential file stage only
can we half project in parallel jobs and half project in server jobs?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
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.
What are the important features of datastage?
How did you reconcile source with target?