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 Dimensional table?

811


How can one identify whether mapping is correct or not without connecting session?

1158


What is a filter transformation and why it is an active one?

776


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

917


What is data transformation manager process?

833


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

1859


How to do the error handling of if ur source is flatfiles?

1736


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3776


what is Active lock explain

2566


What is a snowflake schema?

767


What is the use of code page?

790


What is the need for an etl tool?

845


What is the Process to creating lookup transformation in informatica

805


Explain why we use partitioning the session in informatica?

811


How can you differentiate between powercenter and power map?

849