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
- 4677 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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How you can differentiate between connected lookup and unconnected lookup?
If informatica has its scheduler why using third party scheduler?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Explain sessions. Explain how batches are used to combine executions?
Partition, what happens if the specified key range is shorter and longer
What is informatica worklet?
What is the surrogate key?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the need of an ETL tool?
Explain the different kinds of facts.
Differentiate between Load Manager and DTM?
What are the different components of powercenter?
expain about the tune parameters?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
