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

On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?

Answer Posted / sasi

the best way to do this use the slowy changing dimension in
the mappings-->wizzard-->slowly changing dimension-->type1

here u need to select the source and target tables.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size of u r source(like file or table)?

2228


Explain the different dimensions.

927


What is workflow? What are the components of the workflow manager?

1090


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2690


What is DR strategy for Informatica project?

1134


Explain lookup transformation is active in informatica

1054


if we have a delimiters at unwanted places in a flat file how can we over come those.

2002


define galaxy repository in informatica

2177


How many input parameters can exist in an unconnected lookup?

1514


expain about the tune parameters?

2361


How to load the data from people soft hrm to people soft erm using informatica?

964


 Informatica Checkpoints

3284


What is meant by a domain?

1096


Is there any way to read the ms excel datas directly into informatica?

994


Explain pushdown optimization and types in informatica

1036