Interested to Buy Any Domain ? << Click Here >> for more details...
How can you define a transformation? What are different
types of transformations in Informatica?
- 10 Answers
- 25532 Views
- I also Faced
- E-Mail Answers
Answer Posted / steve
A transformation is a repository object that generates,
modifies, or passes data
Transformations in a mapping represent the operations the
Informatica Server performs on the data
It can be
Connected , unconnected , active or passive
| Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
Which transformation should we use to normalise the COBOL and relational sources?
What do mean by local and global repository?
explain one complex mapping with logic? sales project?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is xml source qualifier transformation in informatica?
Implementation methodology
What are the basic requirements to join two sources in a source qualifier transformation using default join?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What do you mean by enterprise data warehousing?
Differentiate between router and filter transformation?
In informatica workflow manager, how many repositories can be created?
What if the source is a flat-file?
How can we use mapping variables in informatica?
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
