1. Difference between Hashfile and Sequential File?. What is modulus?

2. What is iconv and oconv functions?.

3. How can we join one Oracle source and Sequential file?.

4. How can we implement Slowly Changing Dimensions in DataStage?.

5. How can we implement Lookup in DataStage Server jobs?.

6. What are all the third party tools used in DataStage?.

7. what is the difference between routine and transform and function?.

8. what are the Job parameters?.

9. Plug-in?.

10.How can we improve the performance of DataStage jobs?.

11.How can we create Containers?.

12.What about System variables?.

13 What is the use of Usage analysis ?

14 Different ways a project can be moved to production ?...example ….export-
import and Version control.

15 15 What database is the Datastage repository use …? Answer: Universe Database

16 How is the scheduling done in the project ?

17 Which version of DataStage is used in the project?

18 What are the performance tuning required while dealing with large data ?

19 What do the reject option in transformer do?

20 What is the architecture of datastage?

21 How do you define and use the job parameters?

22 What is stage variables,system variables,environment varaibles?

23 How to use routines in datastage?

24 What is difference between shared-container and local-container?

25 How do you connect to Oracle?

26 Please explain any ETL process that you have developed?

27 What is hash file? Types of hash files.

28 If you are doing any changes in shared-container will it reflect in all the jobs
wherever you used this shared- container?

29 Have u written any custom routines in your project? If so explain?

30 How do you get log info into a file?

31 What is before job subroutine/After job subroutine? When do you use them?

32 How do you backup and restore the project?

33 What is Clear Status File and when do you use it?

34 What is Cleanup Resources and when do you use it?

35 Can I join a flat file and oracle and load into oracle? Is this possible?


36 While loading some data into target suddenly thier is a problem loading process
stopped how can u start loading from the records that were left?

37 What are the general problems that u face in Datastage?

38 What are the various reports that could be generated using this Datastage?

39 How to remove blank spaces from data


40 What is Active and Passive stage?

41 What all are the stages you have used in your project?

42 Could DataStage generate test cases?

43 What is difference between hash file and sequential file

44 What is the difference between Transform and routine

45 What is sequencer?

46 How to take backup of project?