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

Answer Posted / infastudent

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

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does command task mean?

808


Explain how many types of dimensions are available in informatica?

777


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7918


How to open an older version of an object in the workspace?

844


Explain pushdown optimization $pushdownconfig parameter - informatica

913


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6885


Have you worked with/created Parameter file

1410


Can we create a node as a gateway node and the same node can be assigned to a grid?

850


How do you load only null records into target?

951


What is joiner transformation?

756


What is the difference between writing a joiner query in ANSI style and THETA style?

2139


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5358


COM components can be used in Informatica

2095


What is the difference between source qualifier transformations source filter to filter transformation?

849


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1035