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
- 4492 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 is the Process to creating lookup transformation in informatica
Reusable transformation and shortcut differences
what is unit testing?tell me proceedure
What are the types of schemas we have in data warehouse.
Define sessions in informatica etl?
What is an expression transformation in informatica?
What is the format of informatica objects in a repository?
What do mean by local and global repository?
How to go to the older version for a mapping?
What are the guidelines to be followed while using union transformation?
What is the benefit of session partitioning?
Why do you use Mapping Parameter and mapping variable?
How can we update a record in the target table without using update strategy?
What are the data movement modes in informatica?
What is a dimensional model?
