What is Ad-Hoc access? What is the difference between Managed
Query and Ad-Hoc
access?
No Answer is Posted For this Question
Be the First to Post Answer
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
DataStage Scenario based Interview Questions
What are the benefits of datastage?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
What are stage variables, derivations and constants?
How the ipc stage work?
How to convert alpha Numeric values to alpha using functions?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
State the difference between an operational datastage and a data warehouse?
How we can convert rows to columns in datastage?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why