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
- 5535 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
what is repositery?
How a routine is called in datastage job?
What is difference between join, merge and lookup stage?
Describe stream connector?
EXPLAIN SCD
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
I have a few records just I want to store data in to targets cycling way how?
how to implement scd2 in datastage 7.5 with lookup stage
How do y read Sequential file from job control?
What are the different plug-ins stages used in your projects?
Explain Quality stage?
Which algorithm you used for your hashfile?
What could be a data source system?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
