Interested to Buy Any Domain ? << Click Here >> for more details...
What are reusable transformations in how many ways we can
create them?
- 2 Answers
- 9360 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / seshagiri k
A reusable transformation is an object which contains
reusable business logic created by single transformation.
A reusable transformation developed in two ways
1. By using tranformation developer
2. Create a normal transformation and make it reusable by
selecting check box in th properties
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amedela chandra sekhar
Reusable Transformations are
1)Lookup t/r
2)stored procedure
3)sequence generator t/r
two ways we can create
1)Mapplet (multiple t/r)
2)Transformation devloper (single t/r)
| Is This Answer Correct ? | 0 Yes | 2 No |
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 reusable transforamtions?
how to design mapping half of source table records into one target and remaining half into another target
Why we use ENABLE HIGH PRECISION in session properties?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
Why sorter is an active transformation?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
Explain the types of lookup transformation?
Without using any transformations how u can load the data into target?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
How can we improve session performance in aggregator transformation?
Define sessions in informatica etl?
Teradata 
