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
- 19200 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 |
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
How do we call shell scripts from informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain in detail scd type 2 through mapping.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to load last n records of file into target table - informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
Explain the difference between a data warehouse and a data mart?
what is degenerated dimension
what is confirmed dimension?
Teradata 
