Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Wednesday, May 01, 2013
datastage4you QAnT - April2013 - 2
Click here ---> datastage4you QAnT - April2013 - 1
#14. DataStage Server – starting the server
a) DB2
su - db2inst1 -c "db2start“
b) WAS Server
/opt/IBM/WebSphere/AppServer/bin/startServer.sh server1 -user wasadmin -password PASSWORD
c) NODE
/opt/IBM/InformationServer/ASBNode/bin/NodeAgents.sh start
d) Engine
/opt/IBM/InformationServer/Server/DSEngine/bin/uv -admin -start
#15. Work done by "COPY Stage"
a) Columns order can be altered .
b) And columns can be dropped.
c) We can change the column names.
#16. Used sorted data for Aggregator stage for better performance.
#17. Sort the data as much as possible in DB and reduced the use of DS-Sort for better performance of jobs. Avoid the work done by DataStage which is possible in DB ;-)
#18. When you need to run the same sequence of jobs again and again, better create a sequencer with all the jobs that you need to run. Running this sequencer will run all the jobs. You can provide the sequence as per your requirement.
#19. If you are using a copy or a filter stage either immediately after or immediately before a transformer stage, you are reducing the efficiency by using more stages because a transformer does the job of both copy stage as well as a filter stage
#20. Use Sort stages instead of Remove duplicate stages. Sort stage has got more grouping options and sort indicator options.
#21. What is the difference between Inprocess and Interprocess ??
#22. What is the importance of Surrogate Key in Data warehousing?
#23. What are all the types presented in the FUNNEL stage ?
#24. Suppose there are two tables which are not having key column. How can you join them?
#25. How you remove duplicates without using remove duplicate stage?
#26. How can we generate a surrogate key in server/parallel jobs?
#27. which stage has high performance filter or switch stage?