Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.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

what is repositery?

0 Answers   IBM,


What is RCP

5 Answers   CGI, CTS,


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  


What is the process of killing a job in datastage?

0 Answers  


Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,


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?

1 Answers   IBM,


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  


How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,


Explain datastage architecture?

0 Answers  


how many write modes are there in ds

2 Answers   IBM,


if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,


What are constraints and derivations?

0 Answers  


Categories