I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I
SHOULD USE TO CALL SYSDATE?

Answer Posted / palgun

CurrentDate()

U can find many more functions in the transformer stage....

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the roundrobin collector?

643


What are the different type of jobs in datastage?

611


How to manage date conversion in Datastage?

644


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

356


Name the different types of Lookups in Datastage?

733






What is the sortmerge collector?

670


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2017


Can you explain players in datastage?

713


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


What are the different options associated with dsjob command?

947


What is the command line function to import and export the ds jobs?

686


What is the flow of loading data into fact & dimensional tables?

600


How can you write parallel routines in datastage PX?

623


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2185


Which commands are used to import and export the datastage jobs?

990