Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5602 Views
- I also Faced
- E-Mail Answers
Answer / rajesh.dwh
1. B-Tree Index is used for dimension tables because it is
more fastest and efficient than other index type.
6. I think 1st scenario should be more efficient.
thanks & regards:
todbarajesh@gmai.com
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different options associated with dsjob command?
Why do we use exception activity in Datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
job locking methods? How can we unlock the job?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
how to call routines in stages?
What are the steps required to kill the job in Datastage?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
when we will use connected Lookup & Unconnected Lookup
What is datastage engine?
What is the function in Transformer stage can act as Rank Function in oracle
how many dimentions and fact tables used in your project and what are names of it?
Teradata 
