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???
- 3 Answers
- 9061 Views
- HP, I also Faced
- E-Mail Answers
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
What are ETL Tools?
Explain about cumulative Sum or moving sum?
How can a transformation be made reusable?
Explain sql transformation in script mode examples in informatica
Does an informatica transformation support only aggregate expressions?
what is the hint? how to use it to reduce the query processing in program?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is parallel processing in informatica?
Differences between version 7.x and 8.x.
What is update strategy transform?
What is fact table? Explain the different kinds of facts.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Mention few power centre client applications with their basic purpose?
How can you differentiate between powercenter and power map?
What is a shortcut and copy in Informatica and how two are different with each other?
