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

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1941


What are the databases that informatica can connect to windows?

586


What are the main issues while working with flat files as source and as targets ?

657


What the difference is between a database, a data warehouse and a data mart?

599


How can repository reports be accessed without sql or other transformations?

730






What is a sequence generator transformation?

577


What is the advantage of informatica?

650


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

542


What are junk dimensions?

635


How many input parameters can exist in an unconnected lookup?

994


What is an unconnected transformation?

667


What is meant by pre and post session shell command?

627


Which transformation should we use to normalise the COBOL and relational sources?

748


Difference between Data and Index Caches?

660


what is the hint? how to use it to reduce the query processing in program?

6320