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 / naveenkumar
drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
How to extract sap data using informatica? What is abap? What are idocs?
is it possible to index the data in cache of lkp transformation ?
What are the static cache and dynamic cache in informatica?
What is an active transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by active and passive transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Why update strategy and union transformations are active? Explain with examples.
Can you generate sequence numbers without using the sequence generator transformation?
How you can differentiate between connected lookup and unconnected lookup?
How to generate sequence numbers using expression transformation?
What all join we can perform in LOOKUP transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?