|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATASTAGE
DETAILS
Question: How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
Answer: Here is the right conversion:
Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-YDM[4,2,2]") .
|
|
|
Category |
DataStage Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 7742 users |
Added on |
7/26/2011 |
Views |
71513 |
Rate it! |
|
|
Question:
How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
Answer:
Here is the right conversion:
Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-YDM[4,2,2]") . Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How do you pass filename as the parameter for a job?
|
View Answer
|
|
How will you call external function or subroutine from datastage?
|
View Answer
|
|
Dimensional modelling is again sub divided into 2 types.
|
View Answer
|
|
How do you eliminate duplicate rows?
|
View Answer
|
|
What is DS Administrator used for - did u use it?
|
View Answer
|
|
What is DS Designer used for - did u use it?
|
View Answer
|
|
What about System variables?
|
View Answer
|
|
How do you eliminate duplicate rows?
|
View Answer
|
|
What are types of Hashed File?
|
View Answer
|
|
What is DS Manager used for - did u use it?
|
View Answer
|
|
What is DS Director used for - did u use it?
|
View Answer
|
|
How do we do the automation of dsjobs?
|
View Answer
|
|
How do you merge two files in DS?
|
View Answer
|
|
What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this.
|
View Answer
|
|
Importance of Surrogate Key in Data warehousing?
|
View Answer
|
|
How do you fix the error "OCI has fetched truncated data" in DataStage
|
- DataStage Interview Questions & Answers">
View Answer
|
|
What is difference between data stage and informatica
|
View Answer
|
|
I want to process 3 files in sequentially one by one , how can i do that. while processing the files it should fetch files automatically .
|
View Answer
|
|
What Happens if RCP is disable ?
|
View Answer
|
|
Defaults nodes for datastage parallel Edition
|
View Answer
|