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 domain in terms of informatica?
What are mapplets?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
difference between stop and abort
How do you recover rows from a failed session
how tokens will generate?
What is the Difference between PowerPlay transformer and power play reports?
Explain the difference between a data warehouse and a data mart?