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 rejected rows are managed in datastage?
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)
How to convert RGB Value to Hexadecimal values in datastage?
Terminate Activity
What are routines in datastage? Enlist various types of routines.
options available in sequence job to run,validate?
client know skid info?
Define meta stage?
What are the types of containers?
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.
which r the connectors used in san?
What is a datastage job?
How can we improve performance of data stage jobs?
how to implement scd2 in datastage 7.5 with lookup stage
How we can covert server job to a parallel job?