Define repository tables in datastage?
what is the use of skid in reporting?
How do you generate sequence number in datastage?
Difference between data warehousing and olap?
What are the components of ascential data stage?
What is the purpose of interprocessor stage in server jobs?
EXPLAIN SCD
What are the various kinds of the hash file?
What is the purpose of pivot stage?
Notification Activity
How one source columns or rows to be loaded in to two different tables?
Differentiate between hash file and sequential file?
whom do you report?
Why do we use link partitioner and link collector in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)