Salesforce.com Learn & Share
41) Have you have ever worked in UNIX environment and why it is useful in Datastage? Yes, I have worked in UNIX environment. This knowledge is useful in Datastage because sometimes one has to write UNIX programs such as batch…
Read More31) Differentiate between Operational Datastage (ODS) and Data warehouse? We can say, ODS is a mini data warehouse. An ODS doesn’t contain information for more than 1 year while a data warehouse contains detailed information regarding the entire business. (6)
Read More21) Define APT_CONFIG in Datastage? It is the environment variable that is used to identify the *.apt file in Datastage. It is also used to store the node information, disk storage information and scratch information. (5)
Read More11) What is the method of removing duplicates, without the remove duplicate stage? Duplicates can be removed by using Sort stage. We can use the option, as allow duplicate = false. (7)
Read More1) I have 3 jobs a,b & c, which are dependent each other, I want to run a & C jobs daily and b job run only on Sunday. How can I do it? If we have third party tool…
Read More