how can you load data into target table without leading zeor's
Answer Posted / asjad
trim(Col_Nm,'0',L)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
What are the different types of repositories created using informatica?
expain about the tune parameters?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the prerequisite tasks to achieve the session partition?
What is rank transformation?
How to update a particular record in target with out running whole workflow?
Different qualification between a related rotate toward the sky and isolates look upward?
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
Define Pmrep command?
Clarify the aggregator change?
What is sequence generator transformation in informatica?
What is the use of source qualifier?
What is joiner transformation in informatica?
What is meant by LDAP users?