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
- 5626 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 |
tell me abt Datastage trigger?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
What are the functionalities of link partitioner and link collector?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
what is the difference between datasatge and datastage TX?
What is a ds designer?
What are the types of containers and how to create them?
What is the version control how can i apply this in DataStage can any one tell me the anser
Triggers,VIEW,Procedures
how to transfer file from one system to another system in unix? which cmd to be use?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
Teradata 
