Interested to Buy Any Domain ? << Click Here >> for more details...
What are the reusable transforamtions?
- 2 Answers
- 6087 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Reusable transformations can be used in multiple mappings.
When you need to incorporate this transformation into
maping, U add an instance of it to maping. Later if yoU
change the definition of the transformation ,all instances
of it inherit the changes. Since the instance of reusable
transforamation is a pointer to that transforamtion, U can
change the transforamation in the transformation developer,
its instances automatically reflect these changes. This
feature can save yoU great deal of work.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / harithareddy
If you want to perform similar task for diff mappings, and
if your logic is also similar for the diff requirements. in
that case instead of creating multiple mappings, we will
create it once and we will select the option as resuable.
so that we can reuse it in other mappings also.
but if you want to do the modifications in reusable mapping
its not possible. you need to do it in original
transformation it will will reflect all the other instances
of that particular transformation
| Is This Answer Correct ? | 4 Yes | 0 No |
In Which scenario did u used Incremental loading?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
connected and unconnected lookups?
What are the different types of schemas?
What differs when we choose the sorted input for aggregator transformation?
What is the difference between a router and a filter transformation?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
What is the function of union transformation?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Teradata 
