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
- 4593 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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How might one distinguish in the case of mapping is right or not without associating session?
What are the settings that you use to configure the joiner transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What do you understand by SOA of Informatica?
whats the logic to load the lower level of granularity of data to fact table.
what is size of u r database?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is meant by lookup transformation?
How to do unit testing in informatica?
What is a pre-defined event and user-defined event?
What is a difference between complete, stop and abort?
How can you define user defied event?
Define enterprise data warehousing?
What is target designer and target load order?
