Answer Posted / krishnakanth.ch
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
Explain 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?
How to differentiate between the active and passive transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Which transformation is needed while using the Cobol sources as source definitions?
What are the types of schemas we have in data warehouse and what are the difference between them?
without table how to come first record only in oracle?
Can informatica load heterogeneous targets from heterogeneous sources?
How can we use mapping variables in informatica?
Explain the different kinds of facts.
How do you take back up of repository?
How to implement security measures using repository manager?
Under which circumstances, informatica server creates reject files?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is sequence generator transformation in informatica?