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)
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
Separate from a database, an information bazaar, and an information stockroom?
What are the different components of powercenter?
What do you mean incremental aggregation?
What is the maplet?
Differentiate between a database and data warehouse?
How to implement security measures using repository manager?
What are pre and post-session shell commands?
How do you use reject loader.
How to load a Dimension ? and how to load a fact table?
pmscmd startworkflow -sv
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the tasks that source qualifier perform?
Why update strategy and union transformations are active?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is meant by active and passive transformation?