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 EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the issues you have faced in your project? How did you overcome those issues?
What differs when we choose the sorted input for aggregator transformation?
What is a connected transformation?
How many numbers of sessions can one group in batches?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can we store previous session logs?
How to update source definition?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Do you find any difficulty while working with flat files as source and target?
Reusable transformation and shortcut differences
Can u generate reports in Informatica?
What is the difference between a repository server and a powerhouse?
What is a surrogate key?