What are reusable transformations in how many ways we can
create them?
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 |
which one is better either active or passive transformation in informatica
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Design a mapping to load a target table with the following values from the above source?
whether Sequence generater T/r uses Caches? then what type of Cache it is
how lookup is acting as both active and passive ? how is it possitble?
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)?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
How to open an older version of an object in the workspace?
Is it possible to use a client with different version than that of its Informatica server?
what is filelist concept in informatica
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?