Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10969 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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain direct and indirect flat file loading (source file type) - informatica
Slowly changing dimensions, types and where will you use them
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you take back up of repository?
What is the difference between OLTP and ODS?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What is router transformation
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
If I have a index defined on target table and if set it to bulk load will it work ?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What are the modules in Power Center
Teradata 
