use an oracle sequence and create a function to call it inside informatica

How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Question Posted / infastudent

Answer Posted / infastudent

use an oracle sequence and create a function to call it
inside informatica

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain why we use partitioning the session in informatica?

1158

What are batches?

1183

Performance tuning( what you did in performance tuning)

2047

What is deployment group?

1292

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1014

What is a sorter transformation?

1151

What is Data Caches size?

1125

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2368

What is the sql query overwrite in source qualifier in informatica

1137

Explain the shared cache and re-cache?

1162

can we override a native sql query within informatica? Where do we do it?

1162

What is repository manager?

1022

What is meant by pre and post session shell command?

1198

How can we update a record in the target table without using update strategy?

1199

explan ur project architecture?

2125