Read the most frequently asked 55 top DataStage interview questions and answers for freshers and experienced DataStage job interview questions pdf download free.
1. What is the difference between DataStage and Informatica?2. What are the components of Ascential Data Stage?
3. What are System variables?
4. What are the enhancements made in datastage 7.5 compare with 7.0?
5. What is DataStage?
6. What is a merge?
7. What are Sequencers?
8. What is version Control?
9. What is Active and Passive Stage?
10. What are the main features of datastage?
11. Define data aggregation?
12. How the IPC Stage work?
13. What are stage variables?
14. What are the types of Containers?
15. Where the DataStage stored his repository?
16. What is Staging Variable?
17. How do you generate Sequence number in Datastage?
18. What is the difference between Server Job and Parallel Jobs?
19. What is the difference between Account and Directory options ?
20. What are the types of jobs we have in Datastage?
21. What are Routines?
22. What are the Job parameters?
23. What is the difference between Hashfile and Sequential File?
24. What is the use of datastage designer?
25. Explain Datastage architecture?
26. How can we improve the performance in DataStage?
27. What is orabulk Stage?
28. What is APT_CONFIG in datastage?
29. What are orabulk and bcp stages?
30. Why fact table is in normal form?
31. What is Merge Stage?
32. How do you schedule or monitoring the job?
33. What is Container and then types?
34. What is the difference between the local container and shared container?
35. What all are the different way to run a job?
36. How and where you used HASH file?
37. What are the Repository Tables in DataStage?
38. How one source columns or rows to be loaded in to two different tables?
39. What are the types of views in Datastage Director?
40. What are Sequencers?
41. What can we do with DataStage Director?
42. Which algorithm you used for your hashfile?
43. What is a folder?
44. What are the difference types of stages?
45. What is Datastage Engine?
46. What all the types of Jobs you developed?
47. How do you register plug-ins?
48. What is orabulk Stage?
49. What are iConv and oConv?
50. What are the different plug-ins Stages used in your projects?
51. Whats difference betweeen operational data stage (ODS) and data warehouse?
52. How do u convert the columns to rows in DataStage?
53. What is environment variables?
54. What are Stage Variables, Derivations and Constants?
55. What is OCI?
No comments:
Post a Comment