in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / prasuna
Ya ..that is right in case its a table..in case of flat
file..i think we cannot use Over ride ...i think using
sequence generator or by finding rownum in Expression
transformation ..after that by filtering two rows ..we get
the output..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the size of your data warehousing?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a repository? And how to add it in an informatica client?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the cumulative sum and moving sum?
Enlist few areas or real-time situations where informatica is required.
What is aggregate cache in aggregator transformation?
What are the types of presistent cache in look up tr.
Global and Local shortcuts. Advantages.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What do you mean incremental aggregation?
What is an unconnected transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Quickly characterize reusable change?
Mention few advantages of router transformation over filter transformation.