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
- 20699 Views
- Accenture, I also Faced
- E-Mail Answers
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
What is the use of an aggregator cache file?
Explain the informatica workflow?
Why is sorter an active transformation?
What are the types of caches in lookup?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to create the source and target database connections in server manager?
What is sequence generator transformation in informatica?
What is rank transformation in informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is workflow? What are the components of the workflow manager?
What are the informatica performance improvement tips
What is a grid in Informatica?
Could you explain what is enterprise data warehouse?
What do you mean by channel change?
Which version configuration tool used in ur project?
