We have moved to www.dataGenX.net, Keep Learning with us.

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
/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?