GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 262 of 305    Print  
What is the difference between ODBC , DSN , NATIVE and TCP/IP Connections?

  
Total Answers and Comments: 1 Last Update: December 25, 2007     Asked by: N SRIRAM K 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 25, 2007 20:27:00   #1  
komalahanumantharao Member Since: November 2007   Contribution: 12    

RE: What is the difference between ODBC , DSN , NATIVE and TCP/IP Connections?

ODBC is the database drivers  which is used to connect from clinet  to the relational database.
DSN is the data service name which is thename of the odbc name give by the customer inoreder to access from the client
Native Drivers is the drivers which allows the client to acess the source and target after loading them from database to the workspace

TCP/ip it is the protocal used for connecting the remote computers.here the repository contacts with informatica repository server through TCP/IP


 
Is this answer useful? Yes | No

 Related Questions

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Read Answers (4) | Asked by : Deshaireddy

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
Read Answers (4) | Asked by : pratyusha

What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?

Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ...
Read Answers (3) | Asked by : senthilkumarselvaraj

Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan
Read Answers (4) | Asked by : Kamalnayan Maramraj
Tags : RDBMS

Latest Answer : Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools. ...
Read Answers (1) | Asked by : karthik mani

Latest Answer : global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1 ...
Read Answers (2) | Asked by : raj

I want to send the excle sheet as a souce to another excel sheet as target.so i created a mapping with souce excel sheet to target sexcel sheet correctly. but i'm faling to enter the correct connection string in establishing relatonal connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn string for Oracle services)
Read Answers (1) | Asked by : sasha

What is the difference between informatica7.1 and new version 8.1,what are the advantages in new version 8.1.
Read Answers (1) | Asked by : amit (pcpl)

Hi All,I am loading a flat file into a DB2 database.My Session is succeeded but i am getting an error like this""WRITER_1_*_1> WRT_8229 Database errors occurred: FnName: Bind Parameter -- [Striva ][ODBC DETAIL Driver] DTL-00264 DBAPI Error. DB_DESCRIBE failed for file TCCCATCN.;DTL-01252 DBNTC Initial OPEN CONVERSE failed to location "SYSD", rcs 0/2014/-204.;DTL-02006 SQL prepare error. SQLCODE = -204.; DSNT408I SQLCODE = -204, ERROR: AVIPB.TCCCATCN IS AN UNDEFINED NAME; DSNT418I
View Question | Asked by : Sai


 Sponsored Links

 
Related Articles

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

The Difference Between Data Mart and Data Warehouse

The Difference Between Data Mart and Data Warehouse The biggest decision facing most IT managers today is whether or not they should construct the data mart before the data warehouse Many vendors will tell you that data warehouses are hard to build as well as expensive mosgoogle If you listen to som
 

Native HTTP Support in SQL Server 2005

Using Native Support in SQL Server 2005 In this tutorial you will learn about Using Native Support Native Support in SQL Server 2005 and Configuring Native Support mosgoogle Using Native Support SQL Server 2005 has the built in capability of delivering fully functional web services The endpoi
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape