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
- 20925 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / jagadish
step1
drag the source that exceed 2billion records into
mapping designer and connect it to expression
transformation.
step2
add a new column in the same expression trans with
decimal data type in any name assume column name is(PK)
step3
now create a sequence generatr trans and without
changing any property u directly connect the CURVAL port to
the newly creayed column(IN_PK) in the expression trans.
step4
now open the expression ports and add another new
column with decimal datatype assume column name is
(OP_PK),now enable the outport port of this column and open
the expression editor and write this expression{ CUME
(IN_PK)}.finally connect this output port (OP_PK) to u r
target table primary key column..u wil get the sequence no
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the cumulative sum and moving sum?
have u done any performance tuning? how u ll do?
design of staging area?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a sequence generator transformation?
tell me the rules and responsblites in our project(my project is development)
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?
how we can load rejected record's at run time?(not through bad files)
What do you mean incremental aggregation?
What all join we can perform in LOOKUP transformation?
difference between informatica 8.1.1 and 8.6
What are the differences between a connected lookup and unconnected lookup?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How you can differentiate between connected lookup and unconnected lookup?
