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
- 20701 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 do you understand by SOA of Informatica?
What is main use of mapplet?
What does update strategy mean, and what are the different option of it?
Suppose we do not group by on any ports of the aggregator what will be the output?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How many ways a relational source definition can be updated and what are they?
What does role playing dimension mean?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
can u any challenge your project?
wat are deployement groups in informatica, how it will be used for developers
In informatica workflow manager, how many repositories can be created?
Differences between version 7.x and 8.x.
which one is better performance wise joiner or look up
