Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / venkateshmalneni
let the source is like this
first name last name
venkatesh malneni
rajesh tumalla
siva kalle
use an expression t/r create an output port with condition first name||last name
CONNECT THE OUTPUT TO THE TARGET
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the different versions of informatica?
How can repository reports be accessed without sql or other transformations?
How to improve the performance of a session using sorter transformation?
Performance tuning( what you did in performance tuning)
can you please explain me pre session and post session options?
What are the differences between joiner transformation and source qualifier transformation?
Explain incremental aggregation in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is diff b/t sorter t/r and agg have the option sorter property...
Target increases every day even though no new record was inserted
Explain pushdown optimization and types in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
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
explain abt ur project architecture?
