Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10593 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tejeya
If you have any update date column in ur table, u can query
where sysdate-2 to get the last two days records.
| Is This Answer Correct ? | 6 Yes | 4 No |
We can use an expression transformation
add_to_date(sysdate-2) it is retrives last two date using
this we can update the records.
If it wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amedela chandra sekhar
by using date range.we can find latest date updated records.
| Is This Answer Correct ? | 0 Yes | 0 No |
select * from date_Test
where dt between sysdate-2 and sysdate ;
Hope this works....
If not anyone please let me know...
| Is This Answer Correct ? | 1 Yes | 4 No |
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
What are data-driven sessions?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
what is the mechanism of the Master-Detail joining condition?
What are active and passive transformations?
What are the types of data that passes between informatica server and stored procedure?
What is intricate mapping?
What are the mapping paramaters and mapping variables?
How many repositories can we create in Informatica?
How many mapplets u have created? and what is the logic used
How can yoU create or import flat file definition in to the warehouse designer?
Teradata 
