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
- 19156 Views
- Accenture, I also Faced
- E-Mail Answers
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
Differentiate between reusable transformation and mapplet.
Explian the Process of deployment groups in informatica
Where are the source flat files kept before running the session?
What is the surrogate key?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Where can we find the throughput option in informatica?
What is lookup change?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are junk dimensions?
What do you mean by enterprise data warehousing?
How to open an older version of an object in the workspace?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain in detail about scd type 1 through mapping.
How to do unit testing in informatica?
What are the popular informatica products?
