Answer Posted / nagaraju bhatraju
A PL/SQL table is a one-dimensional, unbounded, sparse
collection of homogeneous elements, indexed by integers. In
technical terms, it is like an array
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to load a Dimension ? and how to load a fact table?
How to do unit testing in informatica?
Mention a few design and development best practices for informatica?
What is complex mapping?
What is decode in informatica?
How are the sources and targets definitions imported in informatica designer?
How to create a non-reusable instance of reusable transformations?
what is song in infrmatica...?
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
expain about the tune parameters?
What is the function of union transformation?
how we can load rejected record's at run time?(not through bad files)
How will the document be delivered to me?
Explain your project of banking domian.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
