Does datastage support slowly changing dimensions ?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

Difference between server jobs & parallel jobs?

0 Answers  


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...

5 Answers  


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

2 Answers  


how to sort two columns in single job in datastage.

0 Answers   TCS,


What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  






how can u handle null values in transformer stage.

7 Answers  


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?

3 Answers   Caterpillar,


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?

1 Answers   TCS,


Can aggregator and transformer stages use to sort the data? How ?

2 Answers  


What is a merge?

0 Answers  


How to reverse the string using unix?

0 Answers   CTS,


What are stage variables, derivations and constants?

0 Answers  


Categories