What are reusable transformations in how many ways we can
create them?
- 2 Answers
- 8008 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 |
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
without update strategy how to insert &update?
what is difference between dimention table and fact table?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Is it possible to create multiple domains on a single Informatica server?
whether Sequence generater T/r uses Caches? then what type of Cache it is
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Limitation of REPLACESTR. Is there any character limitation to it.
wf dont have integration severances how you can run?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Teradata 
