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 / sujana

i think v shud use FIRST and LAST functions in aggregator..

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of informatica?

571


What is a shortcut and copy in Informatica and how two are different with each other?

673


what is index?how it can work in informatica

1579


What is intricate mapping?

587


What is domain and gateway node?

692






What is data transformation manager process?

619


Explain lookup transformation source types in informatica

695


What is target load order?

804


How we can create indexes after completing the load process?

613


What is an unconnected transformation?

660


While importing the relational source definition from the database, what are the metadata of source that will be imported?

785


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2322


Explain the pipeline partition with real time example?

650


In development project what is the process to follow for an etl developer from day1

1278


 Informatica Checkpoints

2853