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
- 19199 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 mean by throghput? in informatica
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
In informatica workflow manager, how many repositories can be created?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Explain the different kinds of facts.
How will you update the row without using update statergy?
What are the static cache and dynamic cache in informatica?
WAT IS TEXT LOAD?
Explian the Process of deployment groups in informatica
Explain constraint based loading in informatica
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Teradata 
