-
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...
-
-
Transformation Scope
Explain how transformation scope effects joiner transformation?
-
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...
-
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.
-
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 ...
-
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 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...
-
Find Special Character in Flat File
How to find whether special character is present in flat file's data using Informatica as a ETL tool
janardhanpala
- Jun 14th, 2010
If you want find special symbol in flat file when you are importing from file at that time you can set delimeter -check the option- other and you can type symbol which is in your flat file.
nandagiripradeep
- Jan 25th, 2009
There would be a code page present in the properties of the source definition in case of a flat file. Such as LATIN, WESTERN EUROPEAN. We need to choose proper page code to identify the special characters in flat file.
-
What is meant by transformation error
I want to fail the session if the SAL=5000. How can we do it?
swapnl0201
- Jun 16th, 2010
As I understand your 2nd question.You want to stop/fail session/mapping on some condition.You should use abort function to fail the workflow.
-
Session Performance
How would you improve session performance?
satoru
- Jun 17th, 2010
the first thing before touching the cache of the session is doing a tuning and optimize your mapping. The tuning is in the session in the mapping tab. It allows you to see which transformation is the ...
rajeev_bitspilani
- Dec 28th, 2009
Session performance can be improved by allocating the cache memory in a way that it can execute all the transformation within that cache size.Mainly only those transformations are considered as a bott...
-
Normalizer transformation
How do we normalize data which is in .txt comma seperated by using Normalizer transformation and storing the data in a Dimentional table?
ebullientabhinav
- Jun 22nd, 2010
Use a file delimiter as ',' comma when importing the file.The comma separated rows will now be now converted into columns which you have to name.Use normalizer now where you want
-
What are Target Options on the Servers?
Target Options for File Target type are FTP File, Loader and MQ.
There are no target options for ERP target type
Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table.svivekananda
- Jun 26th, 2010
Relationals db: UPDATE, INSERT, DELETE, TRUNCATEFlat file: Dir / filename
MANOJ KUMARPANIGRAHI
- Feb 21st, 2007
Target option for Flat file,relational file (update ,Insert)
-
What is referential Intigrity error? how ll u rectify it?
pawarpossible
- Jul 2nd, 2010
Check which constarint is getting violated in log and take the action accordingly.
dl_mstr
- Feb 10th, 2008
You have set the session for constraint-based loading, but the PowerCenter Server is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships. Action: Ensure the validity of dependencies between target tables
-
Unconnected Lookup
In which situation do we use unconnected lookup?
Anindya1281
- Jul 4th, 2010
- when we need to call same lookup multiple times in one mapping.For example in a parent child relationship you need to pass multiple child id's to get respective parent id's- when most...
hundwanipankaj
- Apr 6th, 2010
Unconnected Lookup is used when lookup is not used in every reecord. Lookup data is called at the point in mapping that needs it. It can be used in any transformation that support expression. Us...
-
What is the use of CUBE/DIMENSION objects in informatica designer? When do we use them?
satoru
- Jul 7th, 2010
Cube is a multidimensional representation of data. It is used for analysis purpose. A cube gives multiple views of data.
-
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.
svivekananda
- Jul 9th, 2010
1. check in session log + monitor output if the run is successful2. open the target and check the data manually
-
1)What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development
svivekananda
- Jul 9th, 2010
1. check in session log + monitor output if the run is successful2. open the target and check the data manually
Prasad
- Jul 14th, 2006
Hi,If you want to know the performance of a mapping at transformation level, then select the option in the session properties-> collect performance data. At the run time in the monitor you can see it ...
-
How do you identify existing rows of data in the target table using lookup transformation
Can identify existing rows of data using unconnected lookup transformation.
Read Best Answer
Editorial / Best Answer
Answered by: SK
- Aug 30th, 2007
There are two ways to lookup the target table to verify a row exists or not :
1. Use connect dynamic cache lookup and then check the values of NewLookuprow Output port to decide whether the incoming record already exists in the table / cache or not.
2. Use Unconnected lookup and call it from an expression trasformation and check the Lookup condition port value (Null/ Not Null) to decide whether the incoming record already exists in the table or not.doppalpaudi
- Jul 9th, 2010
Lookup Transformation is used to cheek weather the data is present in target or not.This transformation is of 2 types 1. Connected lookup transformation2. Unconnected lookup transformation.By using above both we can cheek the target for data .
svivekananda
- Jun 26th, 2010
We can use both connected and unconnected lookups to check the existing records in the target table.
-
Informatica Interview Questions
Read Best Answer
Ans