Interested to Buy Any Domain ? << Click Here >> for more details...
how can u generate sequence of values in which target has
more than 2billion of records.(but with sequence generator
u can generate upto 2 biliion only)
- 6 Answers
- 20491 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / sridhar tirukovela
By using the variable port in the Expression transformation
we can create more than 2 billion records.
| Is This Answer Correct ? | 10 Yes | 3 No |
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
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ramu
The above answer is correct and also set property like max
value is min value.
| Is This Answer Correct ? | 0 Yes | 1 No |
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.
| Is This Answer Correct ? | 0 Yes | 2 No |
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
| Is This Answer Correct ? | 1 Yes | 9 No |
What do you understand by SOA of Informatica?
how do u use sequence created in oracle in informatica? Explain with an simple example
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
How can i set break points in debugging mode ? can explain steps please?
what is the flat file partition and where have to specify it
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
What are Target Options on the Servers?
How to eliminate duplicate records in informatica mapping? Explain with an example....
How to load a relational source into file taget?
What is the reusable transformation?
What is source qualifier transformation?
Teradata 
