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

What is the session task and command task?

991

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

7872

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1895

What is the maplet?

1040

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

1000

explan ur project architecture?

2005

Where can we find the throughput option in informatica?

996

What are the different components of powercenter?

986

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200

What is informatica? Why do we need it?

1039

How you know when to use a static cache and dynamic cache in lookup transformation?

1792

Define mapplet?

962

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1072

r u done any partitions in ur project?

1751

Differentiate between sessions and batches?

963