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 Answers
- 5627 Views
- I also Faced
- E-Mail Answers
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 |
What is difference between server jobs & parallel jobs?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
Define Routines and their types?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
How did you reconcile source with target?
What is the difference b/w Hash file and Lookup Fileset stages?
Differentiate between validated and Compiled in the Datastage?
How one source columns or rows to be loaded in to two different tables?
What is the use of Row generator stage?
Can you explain kafka connector?
Teradata 
