select * from date_Test where dt between sysdate-2 and sysdate ; Hope t

How to retrieve last two days updated records?

Question Posted / krishnakanth.ch

4 Answers
10587 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how tokens will generate?

2152

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1003

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1925

Explain lookup transformation is active in informatica

1029

How to join three sources using joiner? Explain though mapping flow.

1086

what is mean by complex business rule ?

2106

tell me about your project functionality

2287

What is a transaction control transformation?

1140

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1892

What do you mean by enterprise data warehousing?

1000

Define the various join types of joiner transformation?

940

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2795

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2047

What does role playing dimension mean?

996

Enlist the advantages of informatica.

999