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


Please Help Members By Posting Answers For Below Questions

What are session parameters ? How do you set them?

1375


What is the difference between informatica 7.0 and 8.0?

564


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1471


What are the informatica performance improvement tips

611


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1617






What are connected or unconnected transformations?

627


can anyone suggest best free Talend data integration training online

1256


What is a rank transform?

670


I have a flat file, want to reverse the contents of the flat file

689


What is the fact table?

585


if we have a delimiters at unwanted places in a flat file how can we over come those.

1567


What is the scenario which compels informatica server to reject files?

600


Can we create two repositories on same database instance in oracle?

606


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1641


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

604