Answer Posted / tejeya
Find the space by using the Instr() function and then split
into two.. then merge.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is sorter transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What is the cumulative sum and moving sum?
Explain why we use partitioning the session in informatica?
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 might you approve all mappings in the archive all the while?
How to elaborate powercenter integration service?
What the difference is between a database, a data warehouse and a data mart?
What is meant by lookup transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the need of etl tools?
What are the differences between source qualifier and joiner transformation?
What is primary and backup node?
How to join three sources using joiner? Explain though mapping flow.
What is the surrogate key?
