what is the need of session partitioning... how it is
useful in real time
Answer Posted / amedela chandra sekhar
when you do session partitions ,session performance will be
increase.
ex : session running time 40 minutes before partition
session running time 10 minutes after partition
partition 5 types
key range
hash
pass through
round robin
database
let me if any wrong
chandumba2005@gmai.com
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are ETL Tools?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is a predefined event?
How to extract sap data using informatica? What is abap? What are idocs?
How many transformations can be used in mapplets.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the modules in Power Center
What is an active transformation?
How can you differentiate between powercenter and power map?
How do you load only null records into target?
Where are the source flat files kept before running the session?
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 ?
How are indexes created after completing the load process?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?