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
What are the advantages of informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
what is index?how it can work in informatica
What is intricate mapping?
What is domain and gateway node?
What is data transformation manager process?
Explain lookup transformation source types in informatica
What is target load order?
How we can create indexes after completing the load process?
What is an unconnected transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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.
Explain the pipeline partition with real time example?
In development project what is the process to follow for an etl developer from day1
Informatica Checkpoints