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
- 8829 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 |
What are mapplets? How is it different from a Reusable Transformation?
What is a command that used to run a batch?
whatis the default data driven operation in informatica
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is mapping debugger?
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
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
how will you get 21 to 30 record from 50 records?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Teradata 
