What is the flow of loading data into fact & dimensional tables?
How do you get log info into a file?
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
how to abort the job its matain duplicates?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
How to display errors in datastage?
how will u design file watch jobs?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what is meta data? Explain? Where it is used?
How to use Environment variable's in datastage?(use of process)
What are stage variables, derivations and constants?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
what is factless fact table?