What is hash partition?
Answer / bhanu pratap
Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.
Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber
| Is This Answer Correct ? | 6 Yes | 1 No |
What is the maplet?
i have 2 session s1 execute s2 load first session fail what is the reason?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
How to generate a single mapping for both the historical and incremental load.
What is the difference between a connected look up and unconnected lookup?
Explain how to import oracle sequence into informatica?
In which transformation you cannot drag ports into it?
What are mapplets? How is it different from a Reusable Transformation?
How can we eliminate duplicate rows from flatfile,explain?