Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to retrieve last two days updated records?

Question Posted / chandrasekar

Answer Posted / 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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain sessions?

1067

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8120

Write the program through which the records can be updated?

1006

What is intricate mapping?

1206

Explain the difference between a data warehouse and a data mart?

1057

What is the status code in stored procedure transformation?

1182

Explain the tuning lookup transformation - informatica

996

What is the way to execute pl/sql script using informatica mapping?

1607

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

Implementation methodology

1714

What are the different transaction levels available in transaction control transformation?

1209

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5794

What are the different ways to implement parallel processing in informatica?

1424

Explain why we use partitioning the session in informatica?

1095