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
Define update strategy?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the different lookup methods used in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is meant by active and passive transformation?
What are the tasks that can be performed using sq?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to start a workflow using pmcmd command?
What is the benefit of session partitioning?
Why do you use Mapping Parameter and mapping variable?
What are the uses of etl tools?
What are the different lookup cache(s)?
Can we create multiple integration service on single repository?
How to load a Dimension ? and how to load a fact table?
What are the different components of powercenter?