what is connected and unconnected lookups? 68. scripting means? Explain briefly How it controls the job? 62. what are the orchestrate operators available in datastage for AIX environment 61. value ? Name of an Orchestrate operator to call. What is Orchestrate options in generic stage, what are the option names.
#DIFFERENCES BETWEEN DATASTAGE 7.5 AND 8.5 HOW TO#
how to attach a mtr file (MapTrace) via email and the MapTrace is used to record all the execute map errors 60. Type 30D hash file is GENERIC or SPECIFIC? 59. What is the diffrence between the Dynamic RDBMS Stage & Static RDBMS Stage ? 57. What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard Ascential DataStage 7.5 Version ? 56. how do we create index in data satge? 55. What is parallel execution in oracle? 52. What is page size/array size in oracle? 51. Are there any configurations restrictions ? for particular node? 48. Can one combine pipeline & partition parallelism? How and when? 47. How to remove blank spaces from data? 45. What are the various reports that could be generated using this Datastage? 44. What is Cleanup Resources and when do you use it? 43. What is Clear Status File and when do you use it?Ĥ2. Have u written any custom routines in your project? If so explain 40. Different ways a project can be moved to production ?.example. What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access? 38. how exactly schedule ur jobs ? file watcher jobs ? command watcher jobs? 37. datastage telnet tool where it is and use 34. peekstage and pivot its practical use 29. sparse lookup where its option in oci or db2 28. memory wise difference between lookup merge and join 27. if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this? 26. is the difference between DataStage and DataStage Scripting? 25. What are the new features of Datastage 7.1 from data stage 6.1 24. how can we get basic transformer in parallel jobs? 23. how can we view the data of dataset from hard disk? Not from rightclick view data? 22. ctl(control files) files ? how the dataset stage have better performance by this files? 21. Is there any possibility to generate alphanumeric surrogate key? Explain briefly? 20.
job locking methods? How can we unlock the job? Explain in briefly? 19. where we use config file as parameter ? tell me in the project? 18. how can we create read only jobs in DS? 17. where the log files or tables can store in DS? 16. what is meaning of instance in DataStage? explain with example ? 14. how to drop the index before loading data into target and how to rebuild it in DS? 13. is it possible to access the same job by two users at a time in DataStage? 12. what is job control ? what is the use of it explain with steps? 11. how do u convert date in 20-12-07 to dec-20-2007 or 2 or 20-dec-07 in parallel jobs? 10. how can we create rank using datastage?what is the meaning of rank? 9. root tree will find which is server job and which is parallel job? 8. how can I know no of nodes in unix? And which are working at present? 7. How can I know which Job is working on which node? 6. What is the complex job you have created ? tell me the logic of that complex job? 5. what is the use of DSattchJob?DetachJob? where can we find it? 4. I s there any in-built transform for surrogate key? 3.
0 kommentar(er)
