how to find diff between 2 dates without using Icon...
funtions?



how to find diff between 2 dates without using Icon... funtions?..

Answer / subbuchamala

This function returns number of days from source date to the given date.

DaysSinceFromDate(mylink.sourcedate, mylink.givendate)--->No of days.

Ex:
DaysSinceFromDate(“2014-06-10”,”2014-06-15”)= 5

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is usage analysis in datastage?

0 Answers  


If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,


How did you reconcile source with target?

3 Answers   HP,


hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,


explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,






how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,


j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,


1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  


Lookup constraints

0 Answers   CTS,


why dataset ?

2 Answers  


What are the functionalities of link collector?

0 Answers  


What is the difference between hashfile and sequential file?

0 Answers  


Categories