How can u work with remote database in informatica?did you
work directly by using remote connections?
Answer Posted / swetha
To work with remote datasource u need to connect it with
remote connections. But it is not preferable to work with
that remote source directly by using remote connections
.Instead u bring that source into U r local machine where
informatica server resides. If u work directly with remote
source the session performance will decreases by passing
less amount of data across the network in a particular time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
How can you generate reports in informatica?
What are the uses of etl tools?
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
what is SDLC way of code development?
what is $$$$?
What is decode in static cache?
Plz can any one say me how to get the informatica certification materials and dumps
Explain the code page compatibility?
Which transformation should we use to normalise the COBOL and relational sources?
What is the cumulative sum and moving sum?
how to load rows into fact table in data warehouse
Different qualification between a related rotate toward the sky and isolates look upward?
Differentiate between reusable transformation and mapplet.
Describe data concatenation?