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 |
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
How to find value from a column in a dataset?
What are some different alternative commands associated with "dsjob"?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is snow flack schema?
What is the difference between datastage and datastage tx?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How many nodes supported by a one cpu in parallel jobs?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
HOW CAN U DO ERROR HANDLING IN DATA STAGE?