What is confirmed Dimension?
what is Factless Fact? give one example?
What are Additive, Semi-Additive Facts?
- 1 Answers
- 5667 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 |
what is data mapping
How can we run same job in 1 day 2 times
which dim, fact tables used in bank domain
What is Fastly Changing Dimension?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
how to validate the jobs
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
whats relation between configuration file and datasets?
Which commands are used to import and export the datastage jobs?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Teradata 
