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

If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.

Answer Posted / babu

By selecting 'UPDATE else insert' in the 'Treat source rows
as :'from
session properties we can get updated rows and new rows..

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Repository user profiles

1713


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715


Briefly define reusable transformation?

1075


Write the advantages of partitioning a session?

1203


Explain what are the different types of transformation available in informatica.

1038


What are the differences between a connected lookup and unconnected lookup?

1015


What are session parameters ? How do you set them?

1773


What is a mapplet/worklet in informatica?

1120


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986


Does an informatica transformation support only aggregate expressions?

970


Plz can any one say me how to get the informatica certification materials and dumps

1999


write a query to retrieve the latest records from the table sorted by version(scd)

1004


Different circumstance which drives informatica server to expel records?

915


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

1340


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1009