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
What is joiner change?
define galaxy repository in informatica
What is joiner transformation in informatica?
What are pre and post-session shell commands?
How does a rank transform differ from aggregator transform functions max and min?
What is enterprise data warehousing?
Explain sessions. Explain how batches are used to combine executions?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What does command task mean?
What are the different clients of powercenter?
What are mapplets? How is it different from a Reusable Transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to create a non-reusable instance of reusable transformations?
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
How do you load unique records into one target table and duplicate records into a different target table?