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 lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?

Read Answers (9) | Asked by : reddy

Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ...

Read Answers (3) | Asked by : senthilkumarselvaraj

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

Read Answers (2) | Asked by : kalpana

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

How do i get data in a unconnected lookup transformationi.e if i want to compare customer_id in the source with the customer_id in the unconnected lookup, how can i get the data from the source for the customer_id if it is an unconnected lookupthanksnayana

Read Answers (2) | Asked by : nayana

HI,i am trying to use a flat file and using oracle table as a lookup. when i try to debug its advising invalid mapping. can anyone please help me with this.i also wrote the condition in the lookup as custid=custid.the same is working if i have my source as oracle table.thanksnayana

Read Answers (3) | Asked by : NAYANA

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 : by default  it takes static cache ...

Read Answers (4) | Asked by : BUJJI

What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.

Read Answers (5) | Asked by : Naveen Kumar