Interested to Buy Any Domain ? << Click Here >> for more details...
If we are using an aggregator but forget to mention the
group by port .what will be the output??
- 11 Answers
- 34168 Views
- Nomura, TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 57 Yes | 4 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
can we override a native sql query within informatica? Where do we do it? How do we do it?
In informatics server which files are created during the session rums?
How many ways are there to do 'remove duplicate records in informatica'?
What is workflow manager?
What is the reusable transformation?
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
How do you load first and last records into target table?
What are the main features of Oracle 8i with context to datawarehouse?
without table how to come first record only in oracle?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Differentiate between a database and data warehouse?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the types of schemas we have in data warehouse and what are the difference between them?
What if the source is a flat-file?
