Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1200 records how can u send it in aggregator with
good performance issues?
- 3 Answers
- 9321 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Provide sorted input before aggregation.
->Override default Sql from source Qualifier if the source
is relational-Use order by clause
(OR)
->Use Sorter transfermation to do the same
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is index?how it can work in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a filter transformation and why it is an active one?
What are the components of Informatica? And what is the purpose of each?
What are the advantages of informatica?
What are active and passive transformations?
COM components can be used in Informatica
Explain the etl program with few examples.
Explain sessions?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is flashback table ? Advance thanks
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is union transformation?
