Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?
I am new to Informatica,can anybody suggest me the idea?
- 2 Answers
- 4530 Views
- I also Faced
- E-Mail Answers
Answer Posted / sajid hussain
Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.
Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.
Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3
Step4: Connect all the 3 targets and run the mapping.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the components of workflow manager?
Explain pushdown optimization and types in informatica
Is it possible to revert a global repository to local one and why?
Write the prerequisite tasks to achieve the session partition?
What is meant by target load plan?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can we update a record in the target table without using update strategy?
What is meant by query override?
how to load dimension table and fact table. plz tell me the steps.
What is meant by active and passive transformation?
What are the uses of etl tools?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How does the aggregator transformation handle null values?
How to extract sap data using informatica? What is abap? What are idocs?
What are Dimensional table?
