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 Posted / 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 |
Post New Answer View All Answers
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the types of views in datastage director?
what is the difference between == and eq in UNIX shell scripting?
How do you run datastage job from the command line?
What are datastage sequences?
Define Merge?
How can you write parallel routines in datastage PX?
What are stage variables?
What are the main features of datastage?
How will you move hashed file from one location to another location?
how to abort the job its matain duplicates?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between informatica and datastage?
root tree will find which is server job and which is parallel job?
How many types of hash files are there?