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
- 20718 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 diff b/t sorter t/r and agg have the option sorter property...
What is a dimensional model?
What is meant by target load plan?
How can we store previous session logs?
What's the layout of parameter file (what does a parameter file contain?)?
What is the difference between Active and Passive transformation?
How do you promote a non-reusable transformation to reusable transformation?
Why sorter is an active transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the function of union transformation?
What are the differences between source qualifier and joiner transformation?
Explain pmcmd command usage in informatica
Where are the source flat files kept before running the session?
According to his methodology what all you need before you build a datawarehouse
Explain in detail scd type 2 through mapping.
