-
What is the basic language of informatica?
pradeeshkumar
- Aug 19th, 2010
The Informatica's basic Language is SQL(Structered Query Language). It generates sql queries and that is executed against the database.Informatica is just a tool, that generates SQL queries based on the conditions you specify.
Sravan Gopisetty
- Sep 24th, 2006
The basic language of Informatica is SQL plus.Then only it will under stand the data base language.
-
Normal / Master Outer Join
Why row type should be used only with Normal/Master Outer Join?
pradeeshkumar
- Aug 19th, 2010
In normal join only matching rows from both the master and detail table will be joined and in the case of master outer join all rows from the detail table will be kept and only matching rows from the ...
-
What is Router transformation?
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
pradeeshkumar
- Aug 19th, 2010
Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.But Router transformati...
YugandharS
- Jun 17th, 2010
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
-
Time Dimension
How to load time dimension using Informatica?
laltho
- Aug 29th, 2010
My understanding is time dimension can be loaded by using stored procedure, No live project experience, got info from reading material.
-
$ symbol
$, $$, $$$ what these symbols represents in Informatica?
prashant.baranwal
- Sep 5th, 2010
$ is Session Parameter, Ex: $DBConnection$$ is mapping Parameter/Variable, Ex: $$LastRunDate$$$ is system variable, Ex: $$$SessStartTime
saravanakumar.ashokan
- Aug 29th, 2010
single $ denotes System variableDouble $$ denates User-defined variableTriple $$$ denotes Session Varaiables..You can read on mapping parameter & varaiable in de...
-
Lookup Query
What kind of join (Inner,Outer,FULL) does a lookup generate while being used in a mapping in order to search for a particular field value?
prashant.baranwal
- Sep 5th, 2010
When used in mapping, is generates a inner join by default. However when it returns the value to the system, it does returns a NULL for unmatched records. So we can say that it is left outer join. So we must make sure in which context the question is asked.
-
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.
-
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?
-
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...!
-
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...
-
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.
-
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.
-
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.
-
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.
-
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.
-
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...
-
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.
-
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.
-
How does Informatica get sources from IBM MQ Series
Informatica Interview Questions
Ans