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)
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is the need for an etl tool?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain the scenario which compels informatica server to reject files?
Difference between Data and Index Caches?
server hot-ws270 is connect to Repository B. What does it mean?
Suppose we do not group by on any ports of the aggregator what will be the output?
How do you load first and last records into target table?
How to generate sequence numbers?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain sessions. Explain how batches are used to combine executions?
Why do we need informatica?
What is data transformation manager process?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?