What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
- 2 Answers
- 18202 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sasikumar_bes
if you have increased your commit interval to ~25000 rows
the session will run faster but when your session fails at
24000th record you will not have any data in your target.
When you decrease your commit interval to ~10000 rows your
session will be slow when compared to previous but if the
session fails at 24000th record you will lose only 4000
records.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / anju
if commit interval is set to high value, performance will
be high. if commit is given for every 1000 rows say for eg,
it will affect the performance badly
| Is This Answer Correct ? | 6 Yes | 0 No |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What are the join types in joiner transformation?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Name the different lookup cache(s)?
Explain incremental aggregation in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
How Union Transformation is an Active Trans?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how can one come to know wether the records loak into the target if we use update strategy
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Teradata 
