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

How can repository reports be accessed without sql or other transformations?

732


What is the format of informatica objects in a repository?

603


What are the new features of informatica 9.x developer?

535


explain about unit testing? in real time?

1674


How can you differentiate between powercenter and power map?

627






What do you mean by filter transformation?

557


What are the types of presistent cache in look up tr.

1553


What is rank transformation in informatica

693


Clarify the utilization of aggregator cache record?

580


How do you promote a non-reusable transformation to reusable transformation?

665


What if the source is a flat-file?

595


What is decode in informatica?

663


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1749


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


Is it possible to revert a global repository to local one and why?

615