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
- 20426 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
What is domain and gateway node?
In development project what is the process to follow for an etl developer from day1
What is DR strategy for Informatica project?
How you can differentiate between connected lookup and unconnected lookup?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is INFORMATICA TESTING process
What is an expression transformation in informatica?
What are the mapping parameters and mapping variables?
Differentiate between sessions and batches?
What is sequence generator transformation in informatica?
How union transformation is used?
What is session task and command task?
What is deployment group?
What is a filter transformation and why it is an active one?
