Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
No Answer is Posted For this Question
Be the First to Post Answer
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
how to create document in datastage?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
what is A Datastage?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
how does work server jobs?
When we will go for Data elements?
Is possible to create skid in dim,fact tables?
What is size of a transaction and an array means in a datastage?
State the difference between an operational datastage and a data warehouse?
Hi Vijay here For Four CPU's how many nodes will required?