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?
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 is repositery?
What is RCP
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the process of killing a job in datastage?
Difference between the Sequence and Sequencer in DS?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
Explain datastage architecture?
how many write modes are there in ds
if ename='subbu' while running job the job should be abort how come?
What are constraints and derivations?