I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?
Answers were Sorted based on User's Feedback
Answer / ramesh
In DsMacro the function "DsJobstartDate " is there, by
using this we can recall sysdate
Is This Answer Correct ? | 7 Yes | 1 No |
there many ways to get the SYSDATE:
1) By using the SYSDATE in the select query of your Oracle
Source.
2) By using the DsMacro, the function "DsJobstartDate " in
the transformer.
3) By using Date & Time function - "CurrentDate()" in the
transformer.
4) You would use the Date() function, and then some
variation of the OConv() function to change the date from
internal to external format.
For example, say you want to assign the current date to a
variable called StartDate, and format it in yyyy/mm/dd
format, you would use:
StartDate = Oconv(Date(), "D4/YMD")
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kpk
if i were you i would use a function in the transformer stage.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / palgun
CurrentDate()
U can find many more functions in the transformer stage....
Is This Answer Correct ? | 2 Yes | 1 No |
What is the default padding character?
What are the types of hashed files in data stage
what is the use of materialized view?
Explain ibm infosphere information server and highlight its main features?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
what are the different type of errors in datastage?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
What are transforms and what is the differenece between routines and transforms?
What is Fastly Changing Dimension?
How do you run datastage job from the command line?