Answer Posted / munni
count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What are the different types of repositories created using informatica?
Why do we need informatica?
Is there any target staging area in informatica not staging area
Explain dynamic target flat file name generation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is olap (on-line analytical processing?
Which is the t/r that builts only single cache memory?
What is the difference between informatics 7x and 8x and what is latest version?
What do mean by local and global repository?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a grid in Informatica?
list out all the transformations which use cache?