Interested to Buy Any Domain ? << Click Here >> for more details...
How can u work with remote database in informatica?did you
work directly by using remote connections?
- 2 Answers
- 8576 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rekha
By using UNIX command i.e
$ ftp m get filename we can import the remote database
into our local system.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Explain lookup transformation is active in informatica
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How can yoU create or import flat file definition in to the warehouse designer?
What is powercenter on grid?
how to get max value record into one target and remaining records into another target?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What is union transformation?
Teradata 
