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 / 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 |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
Tell me about MD5 functions in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Is it possible to revert a global repository to local one and why?
Write the program through which the records can be updated?
What are the tuning techniques you applied during your last project
What is an unconnected transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Why union transformation is an active transformation?
What will be the approach?
What are the steps involved in the migration from older version to newer version of Informatica Server?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the different types of repositories created using informatica?
Which files are created during the session rums by informatics server?
What is the command used to run a batch?