How to drop the index before loading data in target and how to rebuild it in Datastage?
How can ETL excel file to Datamart?
What is the transaction size and array size in OCI stage?how these can be used?
What is job control? How it is developed? Explain with steps?
What is the purpose of exception activity in Datastage 7.5?
Other than Round Robin, What is the algorithm used in link collecter? Also Explain How it will works?
How to implement slowly changing dimensions in Datastage?
What does separation option in static hash-file mean?
How to improve the performance of hash file?
How do you check for the consistency and integrity of model and repository?
How we can call the routine in Datastage job? Explain with steps?
What is job control? how can it used explain with steps?
How to find the number of rows in a sequential file?
If the size of the Hash file exceeds 2GB..What happens? Does it overwrite the current rows?
Where we use link partitioner in Datastage job?explain with example?
Can we use shared container as lookup in Datastage server jobs?
What is the meaning of instace in Datastage?explain with examples?
What is the difference beteen validated ok and compiled in Datastage .
What is auditstage,profilestage,qulaitystages in datastge?
What is PROFILE STAGE , QUALITY STAGE,AUDIT STAGE in Datastage
What are the environment variables in Datastage?give some examples?
What is difference between Merge stage and Join stage?
What is the difference between drs and odbc stage ?
Can you tell me for what puorpse .dsx files are used in the datasatage
How do you clean the Datastage repository.
Give one real time situation where link partitioner stage used?
What is environment variables?what is the use of this?
How do you call procedures in Datastage?
Will the Datastage consider the second constraint in the transformer once the first condition is satisfied
How do you do Usage analysis in Datastage ?
How can you implement slowly changed dimensions in Datastage? explain?
Can you join flat file and database in Datastage?how?
How can you implement Complex Jobs in Datastage
What do we do to remedy?
What is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself.
What are constraints and derivation?
Explain the process of taking backup in Datastage?
What are the different types of lookups available in Datastage?
How does Datastage handle the user security?
What are the Steps involved in development of a job in Datastage?
What is a project? Specify its various components?
How to implement type2 slowly changing dimensions in Datastage?Explain with example?
What is meaning of file extender in Datastage server jobs.Can we run the Datastage job from one job to another job that file data where it is stored and what
is the file extender in ds jobs.
What is the max capacity of Hash file in Datastage?