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
- 5624 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 are the areas of application?
To see hidden files in LINIX?
sed,awk,head
Define Data Stage?
What is datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is orabulk stage?
Does datastage support slowly changing dimensions ?
What are the different kinds of views available in a datastage director?
How do you run datastage job from the command line?
Is the value of staging variable stored temporarily or permanently?
What is the difference between the local container and shared container?
What are the types of containers in datastage?
How to RD using transformer?
