Interested to Buy Any Domain ? << Click Here >> for more details...
What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
- 2 Answers
- 19063 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 |
What is a sorter transformation?
How to elaborate powercenter integration service?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
How do you change parameter when you move it from development to production.
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
COM components can be used in Informatica
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
r u done any partitions in ur project?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Teradata 
