-
Define informatica repository?
The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets. The repository also stores administrative...
kiranbabu.jaladi
- Sep 7th, 2011
It is an RDBMS.
It keeps metadata. (information about tha data)
It keeps only logical informatoin. No physical data inside the repository.sithusithu
- Jan 10th, 2006
Infromatica Repository:The informatica repository is at the center of the informatica suite. You create a set of metadata tables within the repository database that the informatica application and too...
-
-
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...
Read Best Answer
Editorial / Best Answer
sanghala- Member Since Apr-2006 | May 14th, 2007
Session: A session is a set of commands that describes the server to move data to the target.
Batch : A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)
There are two types of batches in Informatica:1. Sequential: When Data moves one after another from source to target it is sequential
2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent
ram_infa
- Sep 9th, 2011
Session is nothing, but it tells the integration service, when and how to move the data from sources to target
Group of sessions is called a batch..ravindra
- Jul 15th, 2011
Session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...
-
-
Hi all, recently i was asked by the interviewer like,in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.how to do this. if any one knows how to do this pls. reply.thankskumar
dashingcar
- Apr 19th, 2010
PowerCenter 8.1.1 Performance Tuning Guide The Integration Service looks for the start value of the Variable in the following order: 1.Value in parameter file 2.Value saved in the repository 3.Initial...
-
In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?
ram_infa
- Sep 12th, 2011
In Star schema, the data in the dimensional table is denormalized where as data in the Snow flake schema, it is normalized
ananta.prasad
- May 3rd, 2008
In any schema fact table is in normalized form . it has reference keys to reference dimensional tables. Hence it is normalized
-
How many number of sessions that u can create in a batch?
Any number of sessions.
Syed Muzaffer Uddin
- Jun 22nd, 2011
Any number of session can be created in the batch, but the best practice is to have less number of tasks, it will help at the time of migration.
-
Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?
Informatica server manager.
ram_infa
- Sep 12th, 2011
Workflow manager is used to create,manage sessions and batches
Workflow Monitor is used to monitor, abort/stop the sessionsKarthikeyanVCSS
- Jun 30th, 2011
Informatica Server Manager - Tool that we are using to create and manage Sessions and Batches.
-
What r the types of lookup caches?
Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...
-
What is lookup transformation and update strategy transformation and explain with an example.Thanks in Advance
ram_infa
- Sep 13th, 2011
Look up transformation helps us to look for a data in a flat file,relational,view synonym. Lookup transformation can be used to get a related value and in a slowly changing dimensions Update strategy...
Kathir
- Oct 6th, 2006
In Lookup transformation the source table look to the other tables what the destination you needBut in update stratergy you required empty field you have to fill it
-
Can i use a session Bulk loading option that time can i make a recovery to the session?
ram_infa
- Sep 13th, 2011
Nope! when you use bulk loading you can't recover the rows caz it won't write database logs.
suresh.ravirala
- Mar 17th, 2006
no,why because in bulk load u wont create redo log file,when u normal load we create redo log file,but in bulk load session performance increases
-
-
How to join two tables without using the Joiner Transformation.
ram_infa
- Sep 14th, 2011
If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.
vikota
- Apr 12th, 2011
If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table
-
Discuss which is better among incremental load, Normal Load and Bulk load
Read Best Answer
Editorial / Best Answer
gazulas- Member Since Jan-2006 | Jan 29th, 2006
if supported by the database bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)
ram_infa
- Sep 14th, 2011
It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..
vikota
- Apr 12th, 2011
Incremental load: Incremental means suppose today we processed 100 records ,for tomorrow run u need to extract whatever the records inserted newly and updated after ...
-
What are 2 modes of data movement in Informatica Server?
The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...
Read Best Answer
Editorial / Best Answer
Answered by: purushotham
- Aug 9th, 2005
the two types of modes are:
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.amolrenose
- Sep 18th, 2011
Data Movement Modes
1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.
Data Loading Modes
1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded. -
Explain the informatica Architecture in detail
Read Best Answer
Editorial / Best Answer
Rajsuni- Member Since Apr-2011 | Apr 1st, 2011
Informatica Architecture :
client tools-
Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor
| | | |
(creat,mdify,del-folders, (src&Tar def, (create tasks (display
privilages& access RS) mapings,maPlets)connect to work flow) reult/output)
---------------------
Powercenter tools--
PC service <--------------------->Repository Database
|
|
<-------> PC Server<---->
here: Pc-PowerCenter.
venkat m
- Sep 20th, 2011
Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...
ram_infa
- Sep 15th, 2011
When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...
-
How do you import 500file from tally software in informatica. ?
Hemachandra
- Sep 26th, 2011
With my knowledge BY using LIST FILE we can do
jayapraveen
- Oct 8th, 2010
with my knowledge Consider the 500 file as a flat file and import it considering it as a flat file by fixed length or fixed tab, delimiters OR we can do in this way also by exporting the 500 file as xml file and import in source analyzer by using import from xml file
-
-
Performance tuning in Informatica?
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to network connections. Data generally moves across a network at less than 1 MB per second, whereas a local disk moves data five to twenty times faster. Thus network...
srinivas
- Oct 4th, 2011
Your approach to that question and answer is perfect and correct
ankitmohansharma
- Jan 13th, 2008
Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort.
-
Bridge Table
What is bridge table?
Informatica Interview Questions
Read Best Answer
Ans