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 / gazulas

sql override the sq, using a parameter_value.

select * from xxx where date = parameter_value.

pass the value form par file and run it. only particular date records will be extracted....;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transform?

941


What is flashback table ? Advance thanks

1872


What do you mean by channel change?

965


How do you update the records with or without using update strategy?

1055


How are the sources and targets definitions imported in informatica designer?

1050


What is a predefined event?

1032


Briefly define a session task?

1053


What are active and passive transformations?

1020


What do you mean by enterprise data warehousing?

1002


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9736


What is the benefit of session partitioning?

1042


permutations of mapplet

2454


Explain the mapping variable usage example in informatica

1081


Can informatica load heterogeneous targets from heterogeneous sources?

1118


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