Interested to Buy Any Domain ? << Click Here >> for more details...
What is confirmed Dimension?
what is Factless Fact? give one example?
What are Additive, Semi-Additive Facts?
- 1 Answers
- 6430 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Highlight the main features of datastage?
can we use sequential file as a lookup
Explain entity, attribute and relationship in datastage?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
what are fact tables and dimension tables? give example assuming one table.
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the functionalities of link partitioner and link collector?
how to call sequential generator in datastage?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
Teradata 
