Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8632 Views
- I also Faced
- E-Mail Answers
Answer Posted / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
what is SDLC way of code development?
Is it possible to define a single node as a Gateway node as well as worker node?
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 what transformation and how many are there in informatica?
How do you update the records with or without using update strategy?
what is the hint? how to use it to reduce the query processing in program?
How does a rank transform differ from aggregator transform functions max and min?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Is it possible to revert a global repository to local one and why?
What is the reusable transformation?
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
without table how to come first record only in oracle?
How to create Target definition for flat files?
