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
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
What is a connected transformation?
What are the transformations that are not supported in mapplet?
What are the types of caches in lookup?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain what are the different types of transformation available in informatica.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is meant by pre and post session shell command?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is target load order?
Do you find any difficulty while working with flat files as source and target?
what is the Default Source Option For Update Strategy Transformation?
How to handle decimal places while importing a flatfile into informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
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.