what is the need of session partitioning... how it is
useful in real time
Answers were Sorted based on User's Feedback
Answer / sbvprasad
while need means it increase the perfomance of the session.
. like
hash partitioning.
roundrobin.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / srinivasm22
It actually enhances the session performance.
| Is This Answer Correct ? | 2 Yes | 1 No |
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Why do we need informatica?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
difference between shortcut and reusable transformation?
What is the difference between normal and bulk loading? Which one is recommended?
what is the logic will you implement to load data into a fact table from n dimension tables?
In update strategy target table or flat file which gives more performance ? why?
How to delete duplicate row using informatica?
What are the associated ports in look up T/R.