skip to main
|
skip to sidebar
Search This Blog
Contributors
Kushanoor
flyingcolors
Followers of flyingcolors99
your turn hear
Tuesday, June 21, 2011
What are the different connectivity Informatica uses to connect to sources, targets and the repository ?
Power mart and
Power
Center
uses
1.Network Protocol
2.Native Drivers
3.ODBC
The Server Manager and the Informatica Server uses TCP/IP or IPX/SPX to communicate to each other.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
Installing Informatica PowerCenter In windows 7
Hi All installing the informatica power center on Windows 7( problems resolved) befoere clicking the setup right click on the setup-...
DataWarehousingFundamentals
DataWarehousingFundamentals
Informatica Real Time Scenerios
Split the non-key columns to separate tables with key column in both Scenario 2: Split the non-key columns to separate t...
Dimensional Model
1. Facts 2. Fact Table 3. Dimension 4. Dimension Table
What is the difference between a primary key and a surrogate key?
A primary key is a special constraint on a column or set of columns. A primary key constraint ensures that the column(s) so designated hav...
What is the target load order ?
You specify the target load order based on source qualifiers in a mapping. if u have the multiple source qualifiers connected to the multipl...
How to Process multiple flat files to single target table through informatica if all files are same structure?
We can process all flat files through one mapping and one session using list file. First we need to create list file using unix script f...
What is your tuning approach if SQL query taking long time? Or how do u tune SQL query ?
If query taking long time then First will run the query in Explain Plan, The explain plan process stores data in the PLAN_TABLE. it will ...
Simple senario with solution
I have the source table is Number 1 1 2 3 3 4 Target_unique Target_Duplicates 2 ...
What is the difference between sub-query & co-related sub query ?
A sub query is executed once for the parent statement whereas the correlated sub query is executed once for each row of the parent query. ...
Total Pageviews
Blog Archive
►
2013
(1)
►
09/22 - 09/29
(1)
▼
2011
(201)
►
08/28 - 09/04
(1)
►
07/17 - 07/24
(2)
►
07/10 - 07/17
(1)
►
06/26 - 07/03
(38)
▼
06/19 - 06/26
(26)
Data Warehouse vs. Operational Data Store (ODS)- T...
Difference between Data cleansing and Data scrubbi...
How many repositories can be created in Informatica ?
What is the difference between Local & Global repo...
What is a shared folder ?
What exactly is a shortcut and how do you use it ?
What is the target load order ?
What is the difference between Oracle Sequence and...
What is a reusable transformation? What is a Mappl...
When to index a particular column on what percenta...
What is Click Stream in Data Warehousing ?
Code Page overview ?
What is Code Page Compatibility ?
What are 2 modes of data movement in Informatica S...
What are minimum and maximum values for index and ...
What are cache and their types in Informatica ?
What is Load Manager Process ?
What are connected and unconnected transformations ?
Diff between Active and passive transformation ?
What are reusable transformations ? Can we rollbac...
What are the different connectivity Informatica us...
What is a Variable port ? Why it is used ?
What are different ports in Informatica ?
Difference between PL/SQL and informatica ? Why do...
Strength and weakness of Informatica ?
Contrasting a Data Warehouse with an OLTP System?
►
06/12 - 06/19
(123)
►
05/01 - 05/08
(1)
►
01/09 - 01/16
(2)
►
01/02 - 01/09
(7)
►
2010
(29)
►
08/29 - 09/05
(1)
►
08/08 - 08/15
(5)
►
05/23 - 05/30
(1)
►
04/04 - 04/11
(4)
►
03/21 - 03/28
(10)
►
03/07 - 03/14
(8)
No comments:
Post a Comment