what are the difference between Informatica 7.1 and 8.1?
Answer Posted / sivakumar
1.in 7.1 userdifined function are not there
1.from 8.1on words userdifined function are there
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
Differentiate between a database and data warehouse?
What is persistent lookup cache?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
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
How can we remove the duplicates from flat file source?
What are the advantages of informatica?
what is the -ve test case in your project.
What is informatica?
How is union transformation utilized?
what is the hint? how to use it to reduce the query processing in program?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Which development components of informatica have the highest usage?
Explain the types of lookup transformation?
What is a connected transformation?