Answer / nagaraju bhatraju

generate a sequance values through sequesnce generator and
connet it to the target get the max value of it every time
from unconnected lookup and set this value(maxvalue) to
mapping variable so that the last max value will be stored
in repository. Once the sequance generator is reached its
max value say 2billion , set the property reset to 1 so
that sequence generator will start again to produce
sequance numbers .

and in experession write the logic like

new_seq=max(mapping_variable+sequence_generator (value)
then it is like 2million+1...2......(seq_gen)

every time sequance generator will reset to 1 after
reaching its max value

Answer / sridhar tirukovela

By using the variable port in the Expression transformation
we can create more than 2 billion records.

Answer / jagadish

step1
drag the source that exceed 2billion records into
mapping designer and connect it to expression
transformation.
step2
add a new column in the same expression trans with
decimal data type in any name assume column name is(PK)
step3
now create a sequence generatr trans and without
changing any property u directly connect the CURVAL port to
the newly creayed column(IN_PK) in the expression trans.
step4
now open the expression ports and add another new
column with decimal datatype assume column name is
(OP_PK),now enable the outport port of this column and open
the expression editor and write this expression{ CUME
(IN_PK)}.finally connect this output port (OP_PK) to u r
target table primary key column..u wil get the sequence no

Answer / ramu

The above answer is correct and also set property like max
value is min value.

Answer / amir jalali

Nagaraju's answer is correct except it would be easier to
just use the "cycle" property in the sequence generator and
combine that with the mapping variable to set the keys.

So say we have a mapping variable, $$2Billion = 0 for default.

The value of the keys would be KEY_IN +
($$2Billion)*2,000,000,000

The sequence generator would reset after hitting the 2
billion mark.

Answer / chinna

by using unconnected lookup transformation u can check
condtion ie counter >0 it will be allways true,
or you can use oracle sequence or stored procedure
u have any querries revert me on chinnadw@yahoo.com

What are the different options available for update strategy?

0 Answers  

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

What are the features of complex mapping?

0 Answers  

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

Tell me about MD5 functions in informatica

0 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

When you move from devel to prod how will you retain a variable

1 Answers  

What is update override?

1 Answers   Accenture,