Does datastage support slowly changing dimensions ?
No Answer is Posted For this Question
Be the First to Post Answer
Difference between server jobs & parallel jobs?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
how to sort two columns in single job in datastage.
What is the use of hoursfromtime() function in transformer stage in datastage?
how can u handle null values in transformer stage.
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
Can aggregator and transformer stages use to sort the data? How ?
What is a merge?
How to reverse the string using unix?
What are stage variables, derivations and constants?