-
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.
-
-
-
Mapping and Session Migration
How can we migrate mappings and session from Informatica 6.2 to Informatica 7.1?
-
-
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.
-
Informatica Data Integrity Check
How to check data integrity in Informatica?
-
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?
-
-
-
LookUp Function
What is a look up function? What is default transformation for the look up function?
-
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...!
-
Copy Ports From Source Table
How to copy ports from source table into a transformation which is used in transformation developer?
-
Create Cube using Oracle Database
How to create cube using Oracle Database in Informatica? Give example.
-
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.
Informatica Interview Questions
Ans