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
How to elaborate powercenter integration service?
What is the difference between router and filter?
What do you understand by SOA of Informatica?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are connected or unconnected transformations?
What is a pre-defined event and user-defined event?
How does the aggregator transformation handle null values?
What is a node in Informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Define enterprise data warehousing?
How to differentiate between the active and passive transformations?
Explain load alternative records / rows into multiple targets - informatica
How to do unit testing in informatica?
How to implement security measures using repository manager?