i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater
Answer Posted / pooja
all rows will come, since its not grouped. if its group by,
then last row will be out.
| Is This Answer Correct ? | 3 Yes | 14 No |
Post New Answer View All Answers
What are session parameters ? How do you set them?
what is diff b/t sorter t/r and agg have the option sorter property...
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a grid in Informatica?
What are the different components of powercenter?
how to load rows into fact table in data warehouse
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is lookup change?
Write the advantages of partitioning a session?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Enlist the advantages of informatica.
Can you generate sequence numbers without using the sequence generator transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is a repository manager?