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
- 4577 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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain joiner transformation in informatica
How to delete duplicate row using informatica?
What are the databases that informatica can connect to windows?
scenario where i can use only concurrent execution of workflow.
Describe data concatenation?
expain about the tune parameters?
how to create user defined function (udf) in informatica
Can you generate sequence numbers without using the sequence generator transformation?
What are the different options available for update strategy?
Implementation methodology
What is a dimensional model?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
design of staging area?
What does update strategy mean, and what are the different option of it?
