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

Mention few advantages of router transformation over filter transformation.

1070


difference between repository database and repository service?

1224


whats the logic to load the lower level of granularity of data to fact table.

2312


What is a grid in Informatica?

1119


How would you copy the content of one repository to another repository?

1058


What is different between the data warehouse and data mart?

1114


Can we override a native sql query within informatica?

1092


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

1167


How might you approve all mappings in the archive all the while?

1085


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3928


What is standalone command task?

1376


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1958


What is a difference between complete, stop and abort?

1126


What is an expression transformation?

1080


How does a sorter cache works?

1110