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???

Answers were Sorted based on User's Feedback



hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

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

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / santosh kumar sarangi

you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.

Is This Answer Correct ?    0 Yes 1 No

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

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

More Informatica Interview Questions

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,


when we dont use aggregator in mapping ?

2 Answers   CSC,


Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  


I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


What are the out put files that the informatica server creates during the session running?

2 Answers  


what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,


How is Data Models Used in Practice?

1 Answers  


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


What is predefined event?

1 Answers  


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


Categories