-
Informatica Internal Processes of Integration
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
bpranayreddy
- Jan 5th, 2011
Integration service will in turn call DTM service if the task in a session which will take care of extraction and loading of data......for other sessions like email, cmd it will hand over the task to DM manager which takes care of it. IS just manages the show
-
-
Router Trasmission Logic Expression
What are the logic expression used in router trasmission?
-
Informatica Integration Service
How many Integration Service does Informatica Server contain? only one or many? Explain
-
Session Termination Error
What is session termination? Why does this error occur?
-
SCD Transformation
Can we use both SCD Type1 and Type2 transformations in one mapping? If yes how?
Nagaraju Puppala
- Feb 9th, 2011
Yes,,We should use the both logics in a single mapping in the real time.When an organization maintainig the employee data..It should maintain all historical data like the salary, designations etc. and...
Nagaraju Puppala
- Feb 9th, 2011
Yes,You can create SCD1, SCD2 logic in a single mapping :)Considersd Employe Table: which contains the columns eno, ename, sal, designation, phone, address.while you are loading in to the warehouse ta...
-
Fast Record Append
Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain
jayapraveen
- Feb 11th, 2011
Best way is to have a flag in the data to denote it is last row. =Powercenter reads till end of data and it reads in blocks, so it doesn't =expose the state of the last record.
Surya_prakash
- Feb 10th, 2011
Adding index in to source qualifier and drop the index in the target table.
-
Semi Additive and Factless Fact Tables
Which scenario will use semi additive and factless fact tables?
yagneswarasankar
- Feb 18th, 2011
Semi Additive Facts:A Semi Additive fact is a measure in a table that can be summed up w.r.to some dimentions and can not be or does not have any meaning if we sum up the measure with respect to those...
-
Oracle Sequence Generator and Informatica Sequence Generator
The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Baloo_nanduri
- Jul 25th, 2010
To answer precisely functionality of both is same and even both are at par w.r.t to performance but there are certain limitations Oracle sequence generator is a stored procedure which can be call from...
-
Joiner Transformation Limitations
What are limitations and delimitations of Joiner Transformation?
jyothi_rayala
- Feb 28th, 2011
Joiner transformation cannot be used in the below scenarios ? Both pipelines begins with the same original data source. ? Both input pipelines originates from the same source qualifier. ? Bo...
-
What is meant by EDW?
yugandhar.bo
- May 15th, 2006
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.this apporach is the apporach on Imon which relies on the point of having a single warehouse/centr...
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
Read Best Answer
Editorial / Best Answer
Answered by: Praveen vasudev
- Sep 12th, 2005
Aggregator transform is m uch like the Group by clause in traditional SQL.
this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.
From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.
veepee
sivakp
- Mar 13th, 2011
1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.
shr_4
- Oct 27th, 2010
To perform Group by calculations we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference between both is that Aggregator Transform...
-
Check Existing Rows in Target with Joiner
How to check whether rows existed in target or not by using joiner?
surinr
- Mar 18th, 2011
Use a lookup transformation and compare the target record with source record for existence of the record in the target table.
-
What is DTM? How would you use it in Informatica?
lpmca
- Mar 22nd, 2011
DTM is Data Transformation Manager. Integration Services are used to move data from source to target based on workflow and mapping metadata stored in the repository.Integration services will sta...
-
Informatica Load Manager
What is Load Manager? What is the use of it in Informatica. In which situations would you use it in realtime.
saithirumal
- Mar 26th, 2011
if i run session or workflow that start an DTM process.the main purpose of Load Manager or Balance Load Manager is to find out which node is ideal among the nodes then assign the session task to that ...
-
What are Target Types on the Server?
Target Types are File, Relational and ERP.
Read Best Answer
Editorial / Best Answer
manojkumar_dwh- Member Since Apr-2007 | Apr 14th, 2007
PowerCenter can load data into the following targets:
- Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
- File. Fixed and delimited flat file and XML.
- Application. You can purchase additional PowerCenter Connect products to load data into SAP BW. You can also load data into IBM MQSeries message queues and TIBCO.
- Other. Microsoft Access.
You can load data into targets using ODBC or native drivers, FTP, or external loaders.
-
Power Center Server and Client components
What are the server and client components for Informatica Power Center?
Jaspreet_banga
- Mar 31st, 2011
Client components are:-1.repository manager administration console, 2.designer,3.mapping designer,4.mapplet designer and 5.transformation developerserver components are:-1.integration service 2.repository service3.web hub service4.sap bw service
Sithara Knk
- Mar 20th, 2011
Repository server administration consoleRepository managerDesignerWorkflow managerWorkflow monitor
-
How to pull the data
Hi,How to pull the data from XML and flat files in informatica?How to pull the data from Materialized view in informatica?
-
Discuss the advantages & Disadvantages of star & snowflake schema?
Read Best Answer
Editorial / Best Answer
Answered by: swati
- Nov 5th, 2005
star schema consists of single fact table surrounded by some dimensional table.In snowflake schema the dimension tables are connected with some subdimension table.
In starflake dimensional ables r denormalized,in snowflake dimension tables r normalized.
star schema is used for report generation ,snowflake schema is used for cube.
The advantage of snowflake schema is that the normalized tables r easier to maintain.it also saves the storage space.
The disadvantage of snowflake schema is that it reduces the effectiveness of navigation across the tables due to large no of joins between them.
halgai
- Oct 8th, 2007
Snowflakes are an addition to the Kimball Dimensional system to enable that system to handle hierarchial data. When Kimball proposed the dimensional data warehouse it was not first recogonized t...
Richard
- Feb 2nd, 2006
It depends upon the clients which they are following, whether snowflake or star schema.
-
What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...
Read Best Answer
Editorial / Best Answer
Goush- Member Since May-2007 | May 15th, 2007
When the workflow reaches a session, the Integration Service process starts
the DTM process. The DTM is the process associated with the session and it
performs the following tasks:
1. Retrieves and validates session information from the repository.
2. Performs pushdown optimization when the session is configured for
pushdown optimization.
3. Adds partitions to the session when the session is configured for dynamic
partitioning.
4. Forms partition groups when the session is configured to run on a grid.
5. Expands the service process variables, session, and mapping variables and
parameters.
6. Creates the session log.
7. Validates source and target code pages.
8. Verifies connection object permissions.
9. Runs pre-session shell commands, stored procedures and SQL.
10. Sends a request to start worker DTM processes on other nodes when the
session is configured to run on a grid.
11. Creates and runs mapping, reader, writer, and transformation threads to
extract, transform, and load data.
12. Runs post-session stored procedures, SQL, and shell commands
13. Sends post-session email.
jayapraveen
- Oct 4th, 2010
load manager creates the DTM(data transformation manager)in the work flow manager by the informatica server ,here DTM creates two threads 1.reader thread2.writer threadDTM reads the data from &nb...
chandrarekha
- Sep 6th, 2007
Load manager and DTM are the components of Informatica server. Load manager manages the load on the server by maintaining a queue of sessions and release the session based on first come and firs...
Informatica Interview Questions
Read Best Answer
Ans