I am facing some confusion in informatica key range partition please help me.
When we did the key range partition. suppose if i want to do 4 partitions. so
step1: 4 partitions added
Step2: selected partition type as key range
Step3: selected and added the key column
Step4: i given satrting range and ending rage for the four paritions.
I did the partition like this tell me is there any mistake.
Note: My doubt is after completion of step 4 when we come back to session properties window we will see the 4 partitions with 4 select query. Is there need to mention the range also select query like WHERE CUSTMER_ID BETWEEN 14 AND 50?
Kindly share your valuable views here.
Thanks in advance.