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().
Answer / arkajeet chakravorty
Iconv() function converts the date into internal format.
iconv and oconv is used when we are changing date fomats
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the main differences you have observed between 7.x and 8.x version of datastage?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
how to abort the job its matain duplicates?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
on how many columns we can perform aggregation in the Aggregator stage?
Lookup constraints
Which algorithm you used for your hashfile?
Can aggregator and transformer stages use to sort the data? How ?