GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 232 of 327    Print  
How to generate the sequence of keys or numbers in target without using the sequence generator transformation.

  
Total Answers and Comments: 2 Last Update: October 20, 2007     Asked by: Thejaswini 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 08, 2007 12:37:47   #1  
N SRIRAM K Member Since: May 2007   Contribution: 115    

RE: How to generate the sequence of keys or numbers in...
Use expression transformation with and take a variable with 0 initial value and add 1 to the output.
 
Is this answer useful? Yes | No
October 19, 2007 23:53:25   #2  
Anil kumar        

How to generate the sequence of keys or numbers in...
By using pre SQL in source qualifier we can generate sequence in the target

OR
It can be implemented throuh Lookup Transformation Develope the lookup transformation with condition like NEXTVAL CURVAL+1 Through this conditon we can acheive.

 
Is this answer useful? Yes | No

 Related Questions

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

Latest Answer : We can update the target table, by using the update override in target definition. it will update based on non key columns. ...

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Read Answers (4) | Asked by : Deshaireddy

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Read Answers (5) | Asked by : kishore

Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
Read Answers (3) | Asked by : boobathi

I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Read Answers (1) | Asked by : Adi
Tags : Metadata

Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
Read Answers (9) | Asked by : Adi

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?
Read Answers (6) | Asked by : Reddy

Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan
Read Answers (4) | Asked by : Kamalnayan Maramraj
Tags : RDBMS

I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
Read Answers (2) | Asked by : kalpana


 Sponsored Links

 
Related Articles

SQL Keys

SQL Keys Overview In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be “correct” every time. Referential integrity also prevents records from being “dangled&
 

UML Elements : Sequence Diagram

UML Elements Sequence Diagram In the Unified Modeling Language the sequence diagram is the name that has been given to the Message Sequence Chart The sequence diagram will be responsible for showing various processes or elements that exist together simultaneously and it will often be represented by
 

Data Transformation

Data Transformation is also known as data scrubbing or data cleansing.  It is the formal process of transforming data in the data resource within a common data architecture.  In this  process the production data is decoded and records are merged from multiple DBMS forma
 

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

Oracle Warehouse - Create OWB Target Module

We ll follow the same steps as we did in the last chapter where we created the ACME_WS_ORDERS module. Right-click on the Oracle object under Databases and select New... from the pop-up menu to launch the Create Module Wizard and step through the process. We ll name this module ACME_DWH for ACME Data
 

Oracle Warehouse - Create OWB Target User

There are a couple of ways we can go about creating our target user— create the user directly in the database and then add to OWB or use OWB to physically create the user. If we have to create a new user and if it s on the same database as our repository and workspaces it s a good idea to
 

Oracle Warehouse - Designing the Target Structure

We have our entire source structures defined in the Warehouse Builder. But before we can do anything with them we need to design what our target data warehouse structure is going to look like. When we have that figured out we can start mapping data from the source to the target. So let s design our
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape