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


Please Help Members By Posting Answers For Below Questions

What is informatica worklet?

785


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

761


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.

2588


Where is metadata stored?

778


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2124


How to convert multiple rows to single row (multiple columns) in informatica

1121


What is the function of aggregator transformation?

795


design of staging area?

1797


How does the aggregator transformation handle null values?

906


Differentiate between source qualifier and filter transformation?

1268


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1860


What are the differences between joiner transformation and source qualifier transformation?

871


What do you mean by blocking transformation?

774


What is Index Caches size?

835


which one is better performance wise joiner or look up

828