I have 1200 records how can u send it in aggregator with
good performance issues?
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 |
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
how to return multiple columes through through un-connect lookup?
How to load duplicate records in to a target table which has a primary key?
What are data-driven sessions?
what is diff b/t sorter t/r and agg have the option sorter property...
How will you update the row without using update statergy?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What is the difference between a connected look up and unconnected lookup?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What is informatica powercenter repository?
Can i create a lookup table without cache.
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?