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

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

I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...

Read Answers (2) | Asked by : kalpana

When i try to connect to the repository server i am getting this message can someone help me..Starting Repository [infa_rep](6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.(6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.(6016|1292) Informatica Repository Agent starting up.(6016|1292) Security

Read Answers (4) | Asked by : Raju007

Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq.

Read Answers (2) | Asked by : mayur

1)What are the disadvantages of sequence generator.?2)What is pivate in INFORMATICA.?3)How can we change the rows into columns using INFORMATICA.?

Read Answers (3) | Asked by : Goutam

Latest Answer : Informatica Sequence Generator:Maximum value reached at 2^(31) or 2.147 billion, and will automatically restart at 0. The sequence generator will calculate the max value in the column that you're adding to, and start with max+1 as nextval. ex: your ...

Read Answers (1) | Asked by : channu

Latest Answer : This is because we cannot use a Non Reusable Sequence Generator Transformation in a mapplet. Hence we must use a Re usable Sequence Generator. The fact that we reuse mapplets has no bearing over why we should use a reusable SG. ...

Read Answers (3) | Asked by : Gaurav

How to generate the sequence of keys or numbers in target without using the sequence generator transformation.

Read Answers (2) | Asked by : Thejaswini

Why cant we use a sequence generator or update strategy transformation before a joiner or union transformation?

View Question | Asked by : chandra7