what are the different types of transformation available in informatica and what are the mostly used ?
TCS,
3 23632Post New Informatica Questions
write a query to retrieve the latest records from the table sorted by version(scd)
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is rank transform?
What are data-driven sessions?
What do mean by local and global repository?
How many ways a relational source definition can be updated and what are they?
What is pmcmd command?
What do you understand by a term domain?
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 the components of workflow manager?
Briefly explain the aggregator transformation?
Different circumstance which drives informatica server to expel records?
What is meant by lookup transformation?
What are the different types of transformation available in informatica.
What is an expression transformation?