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

In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data

Answer Posted / santosh kumar sarangi

If sequence generator reached the maximum limit and can't
increase then do as follows.

1. Reset sequence generator to 0
2. Add a expression transformation make an out put port
Out_put_port= max_val_previous_sequence_gen+new_current_val

In this case you can generate next max value.

Let me know if any things wrong.

Thanks $ Regards
Santosh Kumar Sarangi

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wat are deployement groups in informatica, how it will be used for developers

1732


Define mapping and session?

1043


What is workflow manager?

1060


Implementation methodology

1723


scenario where i can use only concurrent execution of workflow.

3186


Name the different lookup cache(s)?

1241


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1141


How we can use union transformation?

1068


How can one identify whether mapping is correct or not without connecting session?

1461


What is the scenario which compels informatica server to reject files?

1083


What are the main issues while working with flat files as source and as targets ?

1174


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1145


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1088


Different circumstance which drives informatica server to expel records?

993


What is the need of etl tools?

1129