Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
expain about the tune parameters?
Explain lookup transformation is active in informatica
What are the new features of informatica 9.x at the developer level?
What are the modules in Power Center
Could you explain what is enterprise data warehouse?
Define enterprise data warehousing?
How to extract sap data using informatica?
What is a joiner transformation?
What is the fact table?
How to generate sequence numbers without using the sequence generator transformation?
How to load the data from people soft hrm to people soft erm using informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
Did u used latest transformations of 8.6.0? for what?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What are the various types of transformation?
