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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to update source definition?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the differences between joiner transformation and source qualifier transformation?
What is option by which we can run all the sessions in a batch simultaneously?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you load only null records into target? Explain through mapping flow.
Tell me about MD5 functions in informatica
how we can load rejected record's at run time?(not through bad files)
What could be the possible resons of locks by user?
Describe an informatica powercenter?
What is a repository manager?
What are the static cache and dynamic cache in informatica?
how to load rows into fact table in data warehouse