Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10961 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 are the components of workflow manager?
According to his methodology what all you need before you build a datawarehouse
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a test load?
Different sorts of metadata that stores in the storage facility?
What is the difference between unicode & ascii mode data movement in informatica?
How do you load first and last records into target table?
What is the use of transformation?
what is upstream and downstream transformation?
Using Connected or unconnected lookup for performance wise which one is preferable?.
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Teradata 
