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
- 20423 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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain how many types of dimensions are available in informatica?
Differentiate between a database and data warehouse?
can u give example for factless fact table
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to create a non-reusable instance of reusable transformations?
what is the Default Source Option For Update Strategy Transformation?
What are the settings that you use to configure the joiner transformation?
What is flashback table ? Advance thanks
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.
What are multi-group transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What can we do to improve the performance of informatica aggregator transformation?
What is joiner transformation?
