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
How to load a Dimension ? and how to load a fact table?
Sequence generator, when you move from develoment to production how will you reset
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain the features of connected and unconnected lookup.
What are Dimensional table?
What are the new features of informatica 9.x at the developer level?
Is it possible to define a single node as a Gateway node as well as worker node?
write a query to retrieve the latest records from the table sorted by version(scd)
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
draw informatica architecture 8.6 ?
What is meant by a domain?
Explain the use of aggregator cache file?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
In warehouses how many schemas are there?