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?
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
How an expression transformation differs from aggregator transformation?
What does refresh system mean, and what are its distinctive choice?
What is a stored procedure transformation?
EXL informatica Questions
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the main issues while working with flat files as source and as targets ?
What is the need of etl tools?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are connected or unconnected transformations?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the Rank index port in Rank transformation?
What are the types of caches in lookup?