difference between shortcut and reusable transformation?
Answer Posted / krithi
Shortcuts allow you to share multiple objects within the
repository i.e., we can use an object in the shared folder
without creating or copying. If the original object
changes, the shortcuts reflects the changes.
Whereas a Reusable Transformation can be used only within
the mappings in that folder.
The shortcuts include:
Source, Target, Tranformation, Mapping, Mapplet,Reusable
Transformation, Business Components.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Do you find any difficulty while working with flat files as source and target?
Is stop and abort are same in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Tell me about Propagate functions in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
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
How to create Target definition for flat files?
Design time, run time. If you don't create parameter what will happen
Define the various join types of joiner transformation?
What is Index Caches size?
What is domain and gateway node?
According to his methodology what all you need before you build a datawarehouse