Interested to Buy Any Domain ? << Click Here >> for more details...
You have defined the following:
- Commit Type = 'Target'
- Commit Interval = 10000
- writer buffer block can hold multiple 7,500 rows
- you are loading 40,000 records into the target
After how many records will the Informatica Server issue
commit commands?
a)7500, 15000, 22500, 30000, 40000
b)15000, 22500, 30000, 37500, 40000
c)15000, 22500, 30000, 40000
d)15000, 30000, 40000
- 7 Answers
- 27291 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sree
the answer is C
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
What differs when we choose the sorted input for aggregator transformation?
Could you explain what is enterprise data warehouse?
What is a dimensional model?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How big was your fact table
Explain the aggregator transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What do you mean incremental aggregation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to do unit testing in informatica? How to load data in informatica ?
What is transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can we use mapping variables in informatica? Where do we use them?
How to differentiate between the active and passive transformations?
