Answer Posted / 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 |
Post New Answer View All Answers
What are stage variables, derivations and constants?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How one source columns or rows to be loaded in to two different tables?
What are the job parameters?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are stage variables?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Where the datastage stored his repository?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the different kinds of views available in a datastage director?
What is size of a transaction and an array means in a datastage?
Give an idea of system variables.
How many types of sorting methods are available in datastage?
What are transforms and what is the differenece between routines and transforms?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise