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
Can we create multiple integration service on single repository?
list out all the transformations which use cache?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the difference between Active and Passive transformation?
What is mapping debugger?
my source is junk data how will u remove that junk data by using unix please any one replay me
Describe the impact of several join conditions and join order in a joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is DR strategy for Informatica project?
How can we create index after completion of load process?
What is aggregate cache in aggregator transformation?
Enlist the tasks for which source qualifier transformation is used.
Explain the mapping variable usage example in informatica
Why do you use Mapping Parameter and mapping variable?
