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

hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???

Answer Posted / sukanta

You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.

You will get the solution.I check it.

Regards
Sukanta

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to revert a global repository to local one and why?

1077


Please let me know how to make encryption and decryption with example?

1896


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

1171


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2096


Why is sorter an active transformation?

1119


Under what condition selecting sorted input in aggregator may fail the session?

1118


Explain target update override in informatica

1118


Briefly explain the aggregator transformation?

993


What are roles and groups and benefits of using them?

1053


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

1108


What are the types of data warehouses?

1514


Why union transformation is an active transformation?

1040


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2129


How can you generate reports in informatica?

1021


How do you convert single row from source into three rows into target?

1151