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 / jz

If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between joiner and lookup transformation?

721


Explain pushdown optimization and types in informatica

747


What are the different ways to implement parallel processing in informatica?

974


lookup transformation with screenshots

3643


What are junk dimensions?

705






Is there any way to read the ms excel datas directly into informatica?

642


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1734


What is the use of transformation?

657


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

810


What does reusable transformation mean?

756


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1691


How an expression transformation differs from aggregator transformation?

709


what are the Methods For Creating Reusable Transformations?

730


What are ETL Tools?

747


What is rank transform?

675