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
How can we handle two sessions in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How do you load only null records into target?
According to his methodology what all you need before you build a datawarehouse
How many ways are there to create ports?
What all join we can perform in LOOKUP transformation?
What do think which one is the better joiner or look up?
Explain the informatica workflow?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to load the data from people soft hrm to people soft erm using informatica?
How can informatica be used for an organization?
What is rank index in rank transformation?
Explain direct and indirect flat file loading (source file type) - informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Do you find any difficulty while working with flat files as source and target?