Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve last two days updated records?
- 4 Answers
- 10834 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 |
Why we select the table which has minimum number of records as Master table in joiner?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
How would you copy the content of one repository to another repository?
what is target update override and when we use it?
How do you load only null records into target?
Explain informatica architecture - version 8 / 9
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
What are mapplets?
What is the need of building a data warehouse?
How to join three sources using joiner? Explain though mapping flow.
Two different admin users created for repository are ______ and_______
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Teradata 
