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 |
how can you load data into target table without leading zeor's
Why we use partitioning the session in informatica?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Explain load alternative records / rows into multiple targets - informatica
what is data driven in update strategy transformation?
how can we calculate fact table size?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
what is the -ve test case in your project.
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Which transformation should we use to normalise the COBOL and relational sources?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how