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 / sridhar tirukovela

By using the variable port in the Expression transformation
we can create more than 2 billion records.

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is joiner change?

932


define galaxy repository in informatica

1963


What is joiner transformation in informatica?

860


What are pre and post-session shell commands?

1030


How does a rank transform differ from aggregator transform functions max and min?

945


What is enterprise data warehousing?

819


Explain sessions. Explain how batches are used to combine executions?

805


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

868


What does command task mean?

836


What are the different clients of powercenter?

836


What are mapplets? How is it different from a Reusable Transformation?

875


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6921


How to create a non-reusable instance of reusable transformations?

909


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1693


How do you load unique records into one target table and duplicate records into a different target table?

978