Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10666 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 Rapid changing dimensions?
Clarify the aggregator change?
How to generate sequence numbers?
What is the status code in stored procedure transformation?
who is the best faculty for informatica in hyderabad ameerpet?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
what is difference between dimention table and fact table?
I have 1200 records how can u send it in aggregator with good performance issues?
What are the challenges you have faced in your project?
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by a domain?
Teradata 
