i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Answer Posted / amedela chandra sekhar

IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.

PLZ LET ME IF ANY WRONG

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the measure objects?

664


Describe expression transformation?

636


What is Cognos script editor?

3788


What are the informatica performance improvement tips

617


Can we create a node as a gateway node and the same node can be assigned to a grid?

641






Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1450


How many input parameters can exist in an unconnected lookup?

994


Is it possible to define a single node as a Gateway node as well as worker node?

663


Explain in detail scd type 2 through mapping.

619


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


How many ways are there to create ports?

731


define galaxy repository in informatica

1729


What is the benefit of partitioning a session?

632


How can one identify whether mapping is correct or not without connecting session?

883


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753