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
- 8836 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 is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
How to improve the session performance in informatica?
how u know when to use a static cache and dynamic cache in lookup transformation.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
What are the out put files that the informatica server creates during the session running?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
disable caching in a lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
Teradata 
