In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
- 6 Answers
- 11415 Views
- I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
if u enable sorted input option in aggregator with out group
by result is one row for all input records.
If u enable sorted input and group by session will fail.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
tell me the rules and responsblites in our project(my project is development)
What is Index Caches size?
How can we create index after completion of load process?
Differentiate between a database and data warehouse?
Mention few power centre client applications with their basic purpose?
In warehouses how many schemas are there?
What is repository manager?
Describe the impact of several join conditions and join order in a joiner transformation?
Is there any target staging area in informatica not staging area
What is powercenter on grid?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the types of lookup transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Difference between Data and Index Caches?
