how to find diff between 2 dates without using Icon...
funtions?
Answer Posted / 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 View All Answers
How to manage date conversion in Datastage?
What are transforms and what is the differenece between routines and transforms?
how to export or import the jobs in .ISX file
Define orabulk and bcp stages?
Can you explain players in datastage?
How to find value from a column in a dataset?
how can we create rank using datastage?what is the meaning of rank?
Distinguish between informatica & datastage. Which one would you choose and why?
Where the datastage stored his repository?
What is a merge in datastage?
Notification Activity
How to reverse the string using unix?
What is the method of removing duplicates, without the remove duplicate stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Is possible to create skid in dim,fact tables?