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
- 20492 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
How you know when to use a static cache and dynamic cache in lookup transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is intricate mapping?
What is an Integration service in Informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What can we do to improve the performance of informatica aggregator transformation?
What is rank index in rank transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is depict expression change?
Enlist the various types of transformations.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is mean by complex business rule ?
can anyone suggest best free Talend data integration training online
What is mapping debugger?
