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
- 20720 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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How do you update the records with or without using update strategy?
How can we update a record in the target table without using update strategy?
What is joiner transformation?
What is dynamic cache?
What is the difference between Active and Passive transformation?
How to partition the Session?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the guidelines to be followed while using union transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain target update override in informatica
expain about the tune parameters?
What you know about transaction control transformation?
What differs when we choose the sorted input for aggregator transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
