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
- 5556 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 Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Differentiate between data file and descriptor file?
what is ds administrator used for?
Have you used Unstructured data?
Difference between data warehousing and olap?
What is ibm datastage?
Name the third party tools that can be used in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is data partitioning?
Why we use surrogate key?
What is the difference between orabulk and bcp stages?
Nls stands for what in datastage?
What are the different type of jobs in datastage?
Differentiate between operational datastage (ods) and data warehouse?
describe the Steps to confiure a Qlogic switch
