Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of transformation available in
informatica and what are the mostly used ?
- 3 Answers
- 25308 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
Lookup,Expression,Rank,Sorter,Agreegator,Update
Strategy,Filter,Router,Source Qualifier,stored
Procedure,Sequence generator and joiner.
The mostly used transformations are :
Lookup, Expression, Agreegator,Router and Update
Strategy,joiner and sequence generator.
sumi..
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
How do you set a varible in incremental aggregation
How can you differentiate between powercenter and power map?
without table how to come first record only in oracle?
What are active transformations.
lookup transformation with screenshots
what is the -ve test case in your project.
How do you promote a non-reusable transformation to reusable transformation?
Design a mapping to load a target table with the following values from the above source?
what is diff b/t sorter t/r and agg have the option sorter property...
Differentiate between router and filter transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are roles and groups and benefits of using them?
What do you mean by filter transformation?
Name the different lookup cache(s)?
what is index?how it can work in informatica
