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...

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2126

---

How does the aggregator transformation handle null values?

1149

---

What is dimensional table? Explain the different dimensions.

1172

---

Can anyone tell me the new features in Informatica 9 Version?

2130

---

What is meant by a domain?

1129

---

What are the advantages of informatica?

1014

---

Have you worked with/created Parameter file

1665

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---

What is the use of code page?

1096

---

permutations of mapplet

2511

---

What is meant by incremental aggregation?

1106

---

What is the session task and command task?

1061

---

What is workflow? What are the components of workflow manager?

1178

---

How to call shell scripts from informatica?

999

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1782

---