-
Session Performance
How would you improve session performance?
satoru
- Jun 17th, 2010
the first thing before touching the cache of the session is doing a tuning and optimize your mapping. The tuning is in the session in the mapping tab. It allows you to see which transformation is the ...
rajeev_bitspilani
- Dec 28th, 2009
Session performance can be improved by allocating the cache memory in a way that it can execute all the transformation within that cache size.Mainly only those transformations are considered as a bott...
-
Power Exchange
What is Power Exchange?
latha.c
- Apr 19th, 2010
Power Exchange deals with the mainframes. CDC (Change Data Capture) source concept also there means?insteed of using delta process logic with different transformations?in the Informatica?PowerCenter, we can create CDC sources in power exchange and import that into power center.ThanksLatha
hundwanipankaj
- Apr 5th, 2010
Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs
-
Informatica Tracking Levels
What are the Tracking levels in Informatica transformations? Which one is efficient and which one faster, and which one is best in Informatica Power Center 8.1/8.5?
SAURABH2301
- Oct 24th, 2009
Also for efficient & faster depends on your requirement.If you want minimum information to be written to the session logs you can use the Terse tracing level.From Informatica Transformation G...
SAURABH2301
- Oct 24th, 2009
I guess you are asking about the tracing level.? When you configure a transformation, you can set the amount of detail the Integration Service writes in the session log.? PowerCenter 8.x support...
-
Which transformation can perform the non equi join?
KRISHNAREDDY
- Jan 27th, 2012
BY USING LOOKUP T/R WE CAN JOIN NON EQUI JOINS
latha.c
- Apr 20th, 2010
Non Equi Join is same as outer join in join transformation. So we can do by using the joiner in Informatica.
-
What is redo log file in Informatica?
jayapraveen
- Oct 4th, 2010
Redo log file keeps the value when the "commit"command executes and replaces the value with new value.
satoru
- Jun 30th, 2010
In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Before a user receives a "Commit complete" message,...
-
Informatica and SAS Exit
-
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.
-
Pipeline Partitioning
Explain the pipeline partitioning with real time example.
sumit dabas
- Aug 3rd, 2011
Pipeline partitioning consist of a long pipe cut(partitioned from between),there r many kinds of pipe..............
prashant.baranwal
- Sep 5th, 2010
Pipline partitioning in Informatica is similar as we have threading concept in Operating System. Here we divide data reading, writing and data transformation in more than one thread such that system c...
-
Informatica Integration Service
How many Integration Service does Informatica Server contain? only one or many? Explain
-
-
Fact table size calculation
How to calculate fact table size.........and how to find fact granularity? Please tell me answers to these 2 questions..
n.sriramk
- Nov 5th, 2010
Size= Number of expected records * E (sum of all columns data type size) bytes
divakar021
- Oct 7th, 2010
A Fact table is calculated based on "lowest level granualarity". The lowest level granualarity can be determined from the ...
-
Aggregator
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
KOTI
- Oct 31st, 2011
First find out the problem whether it is due to aggregator transformation or not. Run debugging...
-
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...
-
Significance of ODBC
What is the significance of the file odbc.ini?
sridkaretl
- Oct 21st, 2011
The main significance of ODBC is it to connect to the desired database and fetch the data.
Sriteja
- Aug 27th, 2011
One of the uses of the ODBC.ini file is to handle SQL Server, Teradata connections from Unix flavoured Informatica Server installations...
There can be more to it.. However, we use odbc.ini in our project to connect SQL Server database from powercenter installed in Linux server.. -
Union Transformation Functions
Which functions are used in Union Transformation?
rangarao.dwh
- Jan 9th, 2012
Union Transformation works like as Union All in SQl and in this transformation we cant use any external functions like avaliable in expersion editor means which is specially designed for joining the records vertically.
sridkaretl
- Oct 21st, 2011
i didnt understand the question. First, a union transformation is active transformation which is used to combine data from multiple sources into single target. This union transformation supports union...
-
Send Flat File Data to Different Targets
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file without adding extra columns?
ETLKaps
- Apr 10th, 2012
For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every r...
sridkaretl
- Oct 21st, 2011
First thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.
-
Star Schema Fact Tables
Is it possible that a Star Schema contains more than one fact tables? If Yes, How?
jayapraveen
- Jun 21st, 2012
Yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschemaRajesh
- Aug 1st, 2011
NO
-
-
Kill workflows
How to kill 10 workflows at a a time ?
vizaik
- Oct 25th, 2011
Write 10 pmcmd commands with abortworkflow option in one bat/sh file and execute at once
wanilkumar
- Oct 7th, 2011
It is not possible to kill multiple workflows at a time. You must Abort/Stop one at a time.
I think starting with the version 8.6 you can run the same workflow multiple times at the same time. -
Structure of the reject file in Informatica
What is the structure of the reject file in Informatica?
Informatica Interview Questions
Ans