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
Answer Posted / vandan
Informatica server issues commit commands as follows as per
your question
15000, 22500, 30000, 37500, 40000
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
How we can use union transformation?
Quickly characterize reusable change?
What is a snowflake schema?
What is dimensional table?
What is the difference between Active and Passive transformation?
Differentiate between a repository server and a powerhouse?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What happens when a session fails and you click on recover?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do mean by local and global repository?
Explain how many types of dimensions are available in informatica?
can you please explain me pre session and post session options?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Where are the source flat files kept before running the session?
What is status code in informatica?