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
Mention few advantages of router transformation over filter transformation.
difference between repository database and repository service?
whats the logic to load the lower level of granularity of data to fact table.
What is a grid in Informatica?
How would you copy the content of one repository to another repository?
What is different between the data warehouse and data mart?
Can we override a native sql query within informatica?
can we override a native sql query within informatica? Where do we do it?
How might you approve all mappings in the archive all the while?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is standalone command task?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a difference between complete, stop and abort?
What is an expression transformation?
How does a sorter cache works?