What are reusable transformations in how many ways we can
create them?
- 2 Answers
- 8732 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 |
What is the command used to run a batch?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
task is running successfully but data is not loded why?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
What is data movement mode in Informatica and difference between them?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
State the differences between sql override and lookup override?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Teradata 
