1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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.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

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

what is repositery?

0 Answers   IBM,

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,




i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

Why do we use exception activity in Datastage?

0 Answers  

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

Define Merge?

0 Answers  

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

For more Data Stage Interview Questions Click Here
Categories