Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?

Answer Posted / sri

For this you can write SQL query by TOP clause in expression
transformation.
Or else You can use Rank Transformation.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On which transformations you created partitions in your project?

757


What are the databases that informatica can connect to windows?

572


How you can differentiate between connected lookup and unconnected lookup?

600


wat are deployement groups in informatica, how it will be used for developers

1244


How to call shell scripts from informatica?

567






What is main use of mapplet?

650


How an expression transformation differs from aggregator transformation?

620


What is the status code in stored procedure transformation?

681


Explain the types of lookup transformation?

560


Define pmcmd command?

616


How does a sorter cache works?

560


How can you differentiate between powercenter and power map?

613


Explain scd type 3 through mapping.

576


What is the surrogate key?

627


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

703