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

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

What is dynamic cache?

0 Answers  

---

Explain the different lookup methods used in informatica?

0 Answers  

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

How many ways you create ports?

1 Answers  

---

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---