how DTM buffer size and buffer block size are related
Answer Posted / anand kumar
(total number of sources + total number of targets)* 2] =
(session buffer blocks)
(session Buffer Blocks) = (.9) * (DTM Buffer Size) /
(Default Buffer Block Size) * (number of partitions)
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain direct and indirect flat file loading (source file type) - informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is size of u r database?
What is the session task and command task?
What do think which one is the better joiner or look up?
Explain what transformation and how many are there in informatica?
Where is metadata stored?
What is a filter transformation and why it is an active one?
How to generate sequence numbers without using the sequence generator transformation?
What is the function of union transformation?