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
Is it possible to revert a global repository to local one and why?
Please let me know how to make encryption and decryption with example?
What is workflow? What are the components of workflow manager?
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
Why is sorter an active transformation?
Under what condition selecting sorted input in aggregator may fail the session?
Explain target update override in informatica
Briefly explain the aggregator transformation?
What are roles and groups and benefits of using them?
How do you update the records with or without using update strategy?
What are the types of data warehouses?
Why union transformation is an active transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can you generate reports in informatica?
How do you convert single row from source into three rows into target?