What is confirmed Dimension?
what is Factless Fact? give one example?
What are Additive, Semi-Additive Facts?
Answer / srinu
The Dimension table which is shared by more than one fact
table is called confirmed dimension
Eg: Time Dimension
The fact table which doesn't have any fact information is
called factless fact table
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain the datastage parallel extender (px) or enterprise edition (ee)?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how to write server Routine coding?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
What is ibm datastage?
What are the primary usages of datastage tool?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to create user defined environment varibale(parameter)?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?