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
- 20498 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
What is joiner change?
How can you differentiate between powercenter and power map?
What are the uses of etl tools?
What is the difference between informatics 7x and 8x and what is latest version?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the different components of powercenter?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is domain in terms of informatica?
what is the complex transformation you used in informatica
Why union transformation is an active transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
EXL informatica Questions
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
During the running session, output files are created by informatica server. Enlist few of them.
What you know about transaction control transformation?
