Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How rejected rows are managed in datastage?

1522


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2730


How to convert RGB Value to Hexadecimal values in datastage?

3998


Terminate Activity

1280


What are routines in datastage? Enlist various types of routines.

1102


options available in sequence job to run,validate?

1320


client know skid info?

2083


Define meta stage?

1205


What are the types of containers?

1237


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044


which r the connectors used in san?

2188


What is a datastage job?

1013


How can we improve performance of data stage jobs?

1017


how to implement scd2 in datastage 7.5 with lookup stage

5605


How we can covert server job to a parallel job?

1147