Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10757 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 |
can we see default group,when we use router?if yes how?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
What is depict expression change?
Mention few power centre client applications with their basic purpose?
What is hash partition?
What are the advantages of informatica?
In informatica workflow manager, how many repositories can be created?
what is mapping optimization? wat are the techniques for tat
how i will stop my workflow after 10 errors
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.
Can we combine a flatfile and a database table using an UNION transformation?
How to delete first 3 rows & last 3 rows in target table in informatica
Teradata 
