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
- 5712 Views
- I also Faced
- E-Mail Answers
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
Can we use target hash file as a lookup ?
What are data elements?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how to implement scd2 in datastage 7.5 with lookup stage
What is the difference between passive stage and active stage?
project Steps,hits, Project level HArd things,Solved methods?
What is the use of hoursfromtime() function in transformer stage in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what are the errors,warnings in datastage
What are constraints and derivations?
What are the important features of datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How you can fix the truncated data error in datastage?
Define oconv () and iconv () functions in datastage?
What is the use of datastage director?
