Answer / tejeya

If you have any update date column in ur table, u can query
where sysdate-2 to get the last two days records.

Answer / chandrasekar

We can use an expression transformation
add_to_date(sysdate-2) it is retrives last two date using
this we can update the records.

If it wrong means please mail me chandranmca2007@gmail.com

Answer / amedela chandra sekhar

by using date range.we can find latest date updated records.

Answer / krishnakanth.ch

select * from date_Test
where dt between sysdate-2 and sysdate ;

Hope this works....
If not anyone please let me know...

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

Without source how to insert record to target?

6 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---