Interested to Buy Any Domain ? << Click Here >> for more details...
What is partioning?how many types of partinings are there
- 2 Answers
- 7657 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vali
to improve the session performance we use the session
partitioning.it improves performance by giving multiple
connections to the source and target.
there are five types of partitioning the session
pass through
data base
round robin
key range
hash partitioning..
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / g. manthiramoorthy
Partition Types:
1.Database partitioning.
2.Hash auto-keys.
3.Hash user keys.
4.Key range.
5.Pass-through
6.Round-robin.
| Is This Answer Correct ? | 6 Yes | 1 No |
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
What is dynamic cache?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is the exact difference b/w IN and EXIST in Oracle..?
How many types of sessions are there in informatica.please explain them?
Is snow flake or star schema used? If star schema means why?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
in which situations do u go for sequence generator ?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How many numbers of sessions can one group in batches?
Tell me one complex query in oracle ?
Teradata 
