1.which index is follows the dimensions tables?why? 2.what is the use of trigge

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?

Question Posted / chandrasekhar.dasg

1 Answers
5636 Views
I also Faced
E-Mail Answers

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? ..

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

Post New Answer

More Data Stage Interview Questions

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers ME,

how can u connect the client system directly at any time?

1 Answers IBM,

how to find out number of records imported into source file?

1 Answers

What is APT_DUMP_SCORE?

2 Answers IBM,

how to load meta data

2 Answers IBM,

What is the difference between odbc and drs stage?

0 Answers

How to create environments and call them? What is the use defined variables?

2 Answers HCL, ME,

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers TCS,

can we half project in parallel jobs and half project in server jobs?

4 Answers Infosys, L&T,

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?

0 Answers Wipro,

What are the areas of application?

0 Answers

For more Data Stage Interview Questions Click Here