Results 1 to 2 of 2

Thread: Create a sequence without using mapping variables and sequence generator - Informatic

  1. #1
    Senior Member
    Join Date
    Aug 2012
    Posts
    40,312

    Create a sequence without using mapping variables and sequence generator - Informatic

    My requirement is to load the surrogate key with sequence values. However i am restricted not to use the sequence generator and mapping variable. Is there any other way to generate the sequence numbers?

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    514
    Follow the below steps:

    create a mapping to write the max value of the surrogate column of the target table into a parameter file.
    Now use this parameter file in the required mapping.
    Now increment the value of the parameter in an expression transformation and pass it to the surrogate port of the target.

Similar Threads

  1. Example program to copy the sequence first, last to a sequence in VC++
    By Maha in forum Visual C++ 5.0 Sample source code
    Replies: 0
    Last Post: 03-04-2013, 06:21 AM
  2. Example program that returns the last location in the sequence in VC++
    By vishnu in forum Visual C++ 5.0 Sample source code
    Replies: 0
    Last Post: 03-04-2013, 06:15 AM
  3. Sequence Values Caching in Netezza.
    By anitha in forum Netezza
    Replies: 0
    Last Post: 10-25-2012, 02:19 PM
  4. Import oracle sequence to informatica
    By vijay in forum Data Warehouse
    Replies: 0
    Last Post: 07-26-2012, 08:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •