Latest Answer : In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ...
The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
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.
Latest Answer : definatly ...
I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana
Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana
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
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.?
What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.
