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
- 9530 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
Before aggrgator transformation it's better to use Sorter
transformation, which will make them as sort, which will
increse the performance.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / drk
By using sorted input and group by function ,we can overcome
the performance issues
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Make a note of the quantity vaults made in informatica?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
why do we go for update strategy tr in SCD rather using the session properties?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
How many joins in Informatica
What are the basic needs to join two sources in a source qualifier?
How will u pas the data with out debugger?
difference between informatica 8.1.1 and 8.6
How does a sorter cache works?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Explain sessions and how many types of sessions are there?
Can a joiner be used in a mapplet.
Teradata 
