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
- 5635 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 run a sequential file stage in parallel if the stage is used on the TARGET side
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Which commands are used to import and export the datastage jobs?
What is the method of removing duplicates, without the remove duplicate stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what is the use of surogate key in datastage
To see hidden files in LINIX?
Can you explain engine tier in information server?
What are data elements?
How one source columns or rows to be loaded in to two different tables?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Define data aggregation?
Difference between data warehousing and olap?
How do you import and export the datastage jobs?
