How you count the number of records available at your source?
Answer Posted / nagaraju
count(*) from table;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
What is transformation?
If informatica has its scheduler why using third party scheduler?
update strategy transformation in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the function of aggregator transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is an expression transformation in informatica?
Write the prerequisite tasks to achieve the session partition?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
can we override a native sql query within informatica? Where do we do it? How do we do it?
Quickly characterize reusable change?
What is meant by LDAP users?
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.