Interested to Buy Any Domain ? << Click Here >> for more details...
if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 22117 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / infa developer
Session fails
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
What are the components of the workflow manager?
What are ETL Tools?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
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 new features of Power Center 5.0?
How does a sorter cache works?
what is the Default Source Option For Update Strategy Transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Which transformation is needed while using the Cobol sources as source definitions?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is informatica etl tool?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the advantages of using informatica as an etl tool over teradata?
explain one complex mapping with logic? sales project?
