-
How do you fine tune the mapping and what methods we follow for different types of transformations?
harikr
- Dec 17th, 2009
A Mapping can be fine tuned for performance at the following levels :1.Optimize the target. 2.Optimize the source3.Optimize the mapping4.Optimize the transformation5.Optimize the session6.O...
-
ETL Tool Complete Process in Informatica
What is the complete process in Informatica power center client tool? Explain using ETL tool
vijaykumar2009
- Dec 9th, 2009
ETL complete process done as fallows: In INFORMATICA POWER CENTER DESIGNER Creation of source table Creation of target table Creation of mapping :plan of implement business logic &nbs...
DK_Reddy
- Apr 19th, 2009
ETL-Extraction (from Source)-Transformation-Loading (to Target)In this process There are 2 servers active at the same time 1) Informatica Server. 2) Repository ServerHere Informatica Server Connec...
-
Session variables - what are they exactly
What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .
harikr
- Dec 7th, 2009
Parameters and variables are not the same.Parameter is one whose value remains the same throughout a session. You can set an initial value/default value.Variable is one whose value changes through the session. You can perform some functions such as MAX or MIN on the variables.
gaurav2485
- Jan 8th, 2009
Yes they are same , But suppose if we define Same variable in Session and mapping with some value then Informatica will take Value which has been defined in Session
-
UNIX commands in informatica
What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?
gaurav2485
- Jan 8th, 2009
We are using Unix in Workflow manager mainly for locating the Source / Target (Flat file) or writing script (if Server is installed in Linux)
-
Transaction Control
Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?
nitijosh
- Nov 22nd, 2009
First Thing as mentioned in the Other Posts it drops all the incoming transaction control boundries.Besides you can use Commit and Rollback statements within SQL Transformation Script to control the transactions, thus avoiding the need for the Transaction Control Transformation.
-
How can use worklet variables and work flow variables
can any one tell me How can use worklet variables and work flow variables Regards Srinu
harikr
- Nov 19th, 2009
Regarding Usage, there is no difference between workflow and worklet variables.Worklet variables are used in worklets. Pre-Worklet Variable Assignment : You can assign the value of the workf...
-
Connectivity Issues
What are the Connectivity Issues that comes when we connect informatica to Oracle?
sppavankumar
- Nov 11th, 2009
There can be different reason for the connectivity to fail. It can be either or combination of below:1) Server is down.2) Wait time for the IS of Informatica is too low.3) Network is slow.4) The OS on the server (usually unix) might have not functioned properly.5) Other Technical Snags
-
What is the difference between source qualifier transformation and filter transformation?
manoj_behera82
- Nov 9th, 2009
Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well. It is capable ...
divakar
- Nov 5th, 2007
A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted? from this? transformation after connecting to the?...
-
What is DTM process?
itisanimesh
- Nov 6th, 2009
The Load Manager creates one DTM process for each session in the workflow. It performs the following tasks: Reads session information from the repository. Expands the server, session, and mapping...
dl_mstr
- Feb 11th, 2008
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
-
Connections and Session
How to make the connections and How to run in session?
ps77322
- Nov 5th, 2009
Connection String Creation:First go to the Work flow manager and then select your folder, then go to Connections menu and select Relational and select the type of database from the drop down and ...
-
Informatica PowerCentre Records
How does Informatica PowerCentre process records?
-
What are all the new features of informatica 8.1?
Senthilkrishnan
- Nov 5th, 2009
# Pushdown Optimization Approach# Grid option# Integration Data Quality# Node setup# Java transformation# Dynamic Partitioning
dl_mstr
- Feb 10th, 2008
Power Center 8 release has "Append to Target file" feature.ava transformation is introduced.User defined functionsMidstream SQL transformation has been added in 8.1.1, not in 8.1.Informatica...
-
Why do we need lookup sql override? Do we write sql override in lookup with special aim?
avneeshrathor
- Nov 3rd, 2009
For some special cases like for example, You need to select the max salary
from emp table for a particular dept. then use
"select max(salary) from emp where deptno=in_dept_no
group by deptno".
Kindly let me know if this is possible without using SQL override in lookup.
ask_kaushik
- Dec 6th, 2007
Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..
-
Newly Added Transformations
What are the newly added transformations in informatica powercenter 8.1.1?
deepthinarayan
- Nov 3rd, 2009
1. Java Transformation
2. HTTP Transformation
3. SQL Transformation
4. Unstructured Data Transformation
-
What r the active and passive transforamtions?
An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.
avneeshrathor
- Nov 3rd, 2009
Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All these are active ones.
sasi.a.kumar
- Aug 14th, 2009
Passive Transformation: When the number of input records to a transformation is equal to the number of output records from the transformation then we call that transformation as Passive Transformation...
-
Eliminate Duplicate Records
HiI am having 10000 records in flat file, in that there are 100 records are duplicate records..soo we want to eliminate those records..which is the best method we have to follow.RegardsMahesh Reddy
avneeshrathor
- Nov 3rd, 2009
Using sorter (with distinct option checked) will not tell what all records were duplicate. There is even a better way of doing it without using aggregator and all. it just uses expression transformation.
-
Using external procedures to extract data from COM objects
Hi, I have an application with integrated COM object. Need to extract some columns of data from that application. Can I use external procedure transformation and try to extract this data directly into INFORMATICA? Please elaborate.. Thanks in advance
ramakrishna.inf
- Jul 8th, 2009
No. Informatica does not extract data from application directly. It will extract only from databases and external sources.
-
StartTask Command
Hi All,I want to ask about StartTask Command if i have 3 steps in the workflow and i want to ignore the first step and start workflow from step 2,so is the StartTask command will start Step2 then step3 or it is only start the step2
avneeshrathor
- Nov 3rd, 2009
Only start step2 task. For step 2 and step 3 both do "start workflow from this task".
N SRIRAM K
- Apr 14th, 2008
You can make the first step (session) disable and run the workflow..it runs all the sessions except the disabled...ThanksSRIRAM N
-
When we are having data in the target table and there are no primary key or foreign key mentioned in the target table then how will you update as well as insert the data?
avneeshrathor
- Nov 3rd, 2009
Use target update override and write down your SQL update statement there. It will not require any keys. Before that use whatever to identify which row qualifies for an update and which not.
vivek1708
- Jul 30th, 2008
It is true - that it wont work without the keys - dynamic look up and update but if the combination of the columns used for look up always returns a unique value - the update shall still work, even if the keys are not defined.
-
What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?
suneetharoy
- Oct 23rd, 2009
Pre SQL: The SQL query fires initially when loading to that database.Example for Pre SQL: Suppose my requirement is to load the records daily. If some updates I have to reload the records for that pa...
sekhar.ganta
- Jan 3rd, 2008
I think above answer may be not correctIn source qualifier t/r : If you write any pre sql? that statement will execute is source database connection before reading the data. If you write that query?...
Informatica Interview Questions
Ans