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 / sree
the answer is C
Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Define enterprise data warehousing?
What is the cumulative sum and moving sum?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a repository? And how to add it in an informatica client?
How can you define user defied event?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What do you mean by worklet?
How can we use mapping variables in informatica? Where do we use them?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Can we override a native sql query within informatica?
what is the complex transformation you used in informatica
How to use pmcmd utility command?
What is transformation?