How to retrieve last two days updated records?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blocking transformation?

713


Design time, run time. If you don't create parameter what will happen

1424


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

628


How do you manage the Parameter files while migrating your data from one environment to another environment?

540


What is Data Caches size?

652






how tokens will generate?

1732


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3319


What is a grid in Informatica?

605


What is DR strategy for Informatica project?

696


What is pmcmd command?

670


How do you use reject loader.

2067


generate date / time dimension in informatica

717


How does the aggregator transformation handle null values?

695


What is data caches/ index caches?

613


What are the designer tools for creating transformations?

677