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
- 5598 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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Could anyone give brief explanation bout datastage admin
how to abort the job its matain duplicates?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between informatica and datastage?
What are the different plug-ins stages used in your projects?
What is the purpose of interprocessor stage in server jobs?
What is the difference between orabulk and bcp stages?
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between Join, Merge and Lookup stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
Have you used Unstructured data?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How many types of hash files are there?
What is apt_config in datastage?
