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 |
How many types of stage?
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?
How do you register plug-ins?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
What are the various kinds of containers available in datastage?
Differentiate between operational datastage (ods) and data warehouse?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
What are the partition techniques available in your last project?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
project Steps,hits, Project level HArd things,Solved methods?
How can you write parallel routines in datastage PX?