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
- 20922 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
waht type of interface is used for testing the data in informatica
What is the difference between a connected look up and unconnected lookup?
What are the various types of transformation?
r u done any partitions in ur project?
what is the size of u r source(like file or table)?
Differences between connected and unconnected lookup?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a grid in Informatica?
What is a mapplet/worklet in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is Index Caches size?
What all join we can perform in LOOKUP transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are junk dimensions?
