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?
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 |
Why fact table is in normal form?
Differentiate between validated and Compiled in the Datastage?
What is the version control how can i apply this in DataStage can any one tell me the anser
how to identifie,is it innerjoin,leftouter join in lookup?
how to closeing records after 10,000 records come?
What is the difference between server job and parallel jobs?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Differentiate between datastage and informatica?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?