-
How does Informatica get sources from IBM MQ Series
-
Data Loading While Session Failed
If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?
reddykuruganti
- Jun 7th, 2010
Simply you can restart the session, by selecting truncate table option in the session properties.
-
Source Qualifier
What is a Source Qualifier?
jayapraveen
- Oct 2nd, 2010
Source qualifier is nothing?but a filter and it is an active transformation, it is used to join the data coming from homogeneous database the best practice of the mapping is using expression before other transformation after the source qualifier.
-
Trace Discarded Data
You transfer 100000 rows to target but some records get discarded, How will you trace them and where its get loaded?
sakshi.chopra
- Sep 26th, 2010
The discarded records can be traced from Reject file. Also optionally you can choose Relational database error logging and the discarded records can be traced from error log tables generated by Integr...
-
What is Code Page used for?
Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, u must select the Japanese code page of source data.
reshhhhhh
- Sep 23rd, 2010
The code page influences the way the application stores, recieves and sends the data. Code page is basically to convert any language to the language that the system understands.
-
Find Mapping or Session Errors
How will you find the errors in mapping or session by sessionlog. What are the alternative options to know the errors?
reshhhhhh
- Sep 23rd, 2010
The sessionlog will give the details of the complete working of the session. With this you can find out where the session failed. In addition session log will also give an error number to provide the type of error that has occurred.Other option to find the error is to debug the session.
-
Event Wait
What is the use of event wait?
sugato.sam
- Sep 22nd, 2010
Event wait is a task created in Informatica to look out for events such as waiting for a file in?the specified directory of the server. Once this task is completed, another workflow dependent on this task will get started.
nagadurgaraju
- Aug 27th, 2010
Event wait is used for loading data proper way, removing deadlock while using schemas.
-
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformation error(2) A reusable unconnected Lookup can not have more than one instance in a mapping(3) An unconnected Lookup transformation does not support user-defined default values(4) An unconnected Lookup transformation does not support a static lookup cache
prashant.baranwal
- Sep 19th, 2010
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformati...
vivek.gce
- Oct 16th, 2008
If there is no match in the Lookup condition, the Informatica server returns a transformation error.
-
What is key factor in BRD?
prashant.baranwal
- Sep 19th, 2010
BRD: Business Requirement Document.key factor could be, understanding of business in terms of design logic.
-
Common Documentation
You need to prepare common documentation of session, source and target. How will you make it?
sraghav20
- Sep 16th, 2010
You should put in appropriate comments/documentation at the metadata extension for each transformation object / mapping / session etc.. Basically for each object.further, you can use metatdata reporter equivalent to generate appropriate document for the mapping/folder etc...
-
Create Cube using Oracle Database
How to create cube using Oracle Database in Informatica? Give example.
-
Copy Ports From Source Table
How to copy ports from source table into a transformation which is used in transformation developer?
-
What are the locks with respect to mappings?How do you manually lock or unlock the mappings for chages?
ramachchandran
- Sep 14th, 2010
In Informatica locks are automatically created. to manually lock or unlock. Go to the admin console, select a repository and click the lock tab. using that you can create lock and release lock if al...
Pandit
- Oct 18th, 2007
If your PowerCenter repository is version-enabled, then you need to check-out /check-in in order to modify any objects (incl.. mappings). This is how you do the version control and locking on objects...!
-
LookUp Function
What is a look up function? What is default transformation for the look up function?
-
-
-
Star Schema
How many star schemas can you use in a project? Is it possible to use more one star schemas?
-
Metadata Repository
Is metadata repository informatica a file format or database format?
-
Informatica Data Integrity Check
How to check data integrity in Informatica?
-
What is DTM process?
After the loadmanger performs validations for session,it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread.Master thread creates and manges all the other threads.
a.himakar
- Sep 7th, 2010
It is the main processing unit in Informatica for executing the session with corresponding mappings. It has 3 sub services as 1) Reader Thread : It uses source table and source connections to ex...
ASHOK1324
- Apr 21st, 2009
The DTM process creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
Informatica Interview Questions
Ans