how to find diff between 2 dates without using Icon...
funtions?
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 |
What is the method of removing duplicates, without the remove duplicate stage?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
Why do we use link partitioner and link collector in datastage?
On which Dimension Table you implemented SCD Type in your Project
What are the different type of jobs in datastage?
Describe the architecture of datastage?
What is the use of datastage director?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
What is the difference between Datastage 7.5 and 7.0?
how to call routines in stages?
How will you move hashed file from one location to another location?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?