-
What are the challenges you have faced in your Project (DWH-ETL)? Explain with example?
Please give suggession. This question was asked by employer recently. Thanks in advance.
satoru
- Jun 10th, 2010
In ETL- The configuration system was not enough to use informatica (too long, too many IS, to many problems to access databases, etc)- Developping new specifications : the specifications were inc...
-
How do you recover a session or folder if you accidentally dropped them?
satoru
- Jun 10th, 2010
You disconnect from repository without saving or if you're using versioning you can look in the check_out option from all users and restore them, though if you delete the folder you can restore it by versioning.
hanug
- May 8th, 2007
u can find ur backup and restore from the backup. If u dont have backup,u lost everything. u cant get it back.Thats why, we should always take the backup of the objects that we create.Hanu.
-
What is the difference between power connect and power centre? What is the use of power connect.
satoru
- Jun 10th, 2010
Power Connect is used to connect and import sources from external systemslike for example Mainframe(IMS, DB2, VSAM) or ERP or MQ Series, etc.We don't have ODBC connections to these sources and so ...
-
What is the meaning of threshold error in Informatica?
ajaybhosal
- Jun 4th, 2010
When the target is used by Update Strategy T/R DD_REJECT, DD_UPDATE with some limited count, and if the number of rejected records exceed that count, then the session ends with failed status. This error is known as threshold error.
-
Informatica objects File Format
What is the file extension and format of the files for the Informatica objects like Mappings, sessions etc in the repository ?
virendra.jaipur
- May 21st, 2010
If you store them in repository, it obvisouly is in terms of relational tables.But if these objects are stored/exported outside the repository, as files; that is when they are stored as xml format files.
sameer_solidcore
- Feb 20th, 2009
Repository is nothing but a database, rather a relational database, and in a relational database anything and everything is stored in tables. And tables are nothing but files with pointers. So in a re...
-
Transformation Scope
Explain how transformation scope effects joiner transformation?
-
-
Look override
Explain the suppress comment in lookup override?
khurana29_amit
- May 16th, 2010
If I write the overide query for lookup without order by and "--" at the end then will it take order by from default query?
madhu.tella
- Mar 25th, 2010
Lookup override is nothing but just simply overriding the default sql which is generated by lookup by the runtime, default SQL contains SELECT and ORDER BY caluse and the order by clause ord...
-
Partitioning, Bitmap Indexing (when to use), how will the bitmap indexing will effect the performance
Anindya1281
- May 16th, 2010
Bitmap indexes are widely used in data warehousing environments. The environments typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions. For such appl...
Shanmugam
- Jul 6th, 2006
Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm...
-
How to extract 10 records out of 100 records in a flat file
Anindya1281
- May 11th, 2010
There are multiple ways to do it src-->seq gen --> trans --> tgtUse a seq gen to get transaction id1) Filter TransUse filter to filter in transaction id<=102) RouterRoute transaction id<...
afzal
- Nov 3rd, 2006
hi,For falt file sourecsource--sq--sequence generator tran.on new fileld id--filter tran. id<=10--traget
-
HOw do u select duplicate rows using informatica?
Anindya1281
- May 11th, 2010
This can be done using SQL query in case of relational sourcesvariables in an expression in case of reltn and flat file srcsIn case of Infa 8.x we have an inbuilt function called MD5 which can be used...
sravan
- Nov 4th, 2006
We can aso use sorter transfermation.seect distinct one check box.
-
Informatica Transformation Scenarios
Outline different transformation scenarios.
-
How does normalizer works
Can some one tell how normalizer works with an example? Please
hundwanipankaj
- Apr 21st, 2010
Normalizer is used with COBOL database, In COBOL database data is stored in denormalized form, It is used to create multiple rows from single row of data or in other words it converts denormalized data into normalized form.
RAJ
- Aug 3rd, 2006
Normalization is used to transform non tabular data structure into tabular format mainly required for COBOL data files.
-
Power Exchange
What is Power Exchange?
latha.c
- Apr 19th, 2010
Power Exchange deals with the mainframes. CDC (Change Data Capture) source concept also there means?insteed of using delta process logic with different transformations?in the Informatica?PowerCenter, we can create CDC sources in power exchange and import that into power center.ThanksLatha
hundwanipankaj
- Apr 5th, 2010
Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs
-
Create a New Domain in Informatica
How to create a new domain in Informatica PowerCenter Repository Manager? What is the Gateway Host and Gateway Port to create a new domain?
-
What is the difference between Informatica server, Repository Server and Power center Server ?
Can any one explain clearly the difference between Informatica server, Repository Server, Power center Server ?
latha.c
- Apr 16th, 2010
Informatica is company name and Power Center is its product. Its advantage is build it once and deploy it anywhere. In Informatica Architecture we have 3 major components called 1. Client to...
akmohanty
- Feb 14th, 2007
Both the Informatica Server and Power Centre server are same meaning in Informatica.Its working to work proceedings for sessions and workflows in workflow Manager windows.The Repository server of Inf...
-
Fact Table - Grain Facts
What are Grain Facts?
Anindya1281
- Apr 15th, 2010
In simple words grain can be considered as the lowest level in which you can store data in a table for example you want to store daily sale of a product and you have different stores so store_id ...
AVRKAM
- Jan 3rd, 2010
This is about granularity. that is, what level of data detail should be made avaialble in the dimension model. A reference to ATOMIC DATA has to be made here.Atomic data is the most expressive da...
-
Informatica Project Locks
How to open project locks in Informatica?
-
Accessing AEP
How can we access the AEP (Advanced External Procedure) in Informatica8.1?
-
How do you join the table if there is no relation ship
question was asked from accenture and Wipro.
vamannam
- Apr 12th, 2010
The main aim of your question is that you have to load the both table’s data in to your target table with joining of the two tables even if you don’t have a common column to join both tabl...
sridhar.gonda
- Oct 27th, 2007
U hav to create a dummy common column in both tables thn u can join both tables.
Informatica Interview Questions
Ans