-
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?...
-
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
-
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...
-
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.
-
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)
-
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
-
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...
-
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...
-
Union Transformation
Why Union Transformation is active while it passes all the rows through it.
etluser
- Dec 28th, 2009
By definition, a transformation is treated as active if the number of input rows do not match the number of output rows. Since Union transoformation accepts input rows from multiple pieplines, and com...
-
What will be the way to send only duplicate records to the Target?
sheeladere
- Dec 30th, 2009
If you want to directly get the records from some relational table then you can use the query in Source qualifier to group by on all the columns and get the count of records and pass the records which...
sanjeev
- Aug 6th, 2007
If you take a ex:EMP TABLE? having the duplicate recordsThe query isSELECT *FROM EMP WHERE EMPNO IN SELECT EMPNO FROM EMP GROUP BY EMPNO HAVING COUNT(*)>1;Sanjeeva Reddy
-
Individual Sequence Numbers
How to create individual sequence numbers for each department wise?
etluser
- Jan 3rd, 2010
Here are the steps1. Assume that there are four departments and that the source is a source file that contains dept id.2. Create four Sequence Generator transformations.3. Create an exp...
-
Importing data through fixed-width wizard
When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a n character.
sheeladere
- Jan 4th, 2010
In the Fixed width file, the columns will be allotted with some specific length( fixed width), suppose your file contains 5 columns and total length of the file record is 100, then while defining...
Motilal
- Jun 30th, 2006
Ya.. Can anybody please give any suggestions?I think the source file needed to be cleaned manually
-
Retrieve only Distinct Record from 'flatfile' Source
How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
sheeladere
- Jan 5th, 2010
We can use Aggregate transformation for this. Group by on all the columns in the Aggregator and get only first or last record from the group, it will give you distinct records.But sorter is the best option, I am not sure why you want to avoid it, is there any specific reason?
jsrprasad0402
- Sep 22nd, 2009
Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along...
-
Target Data Loading
How & Where will you can see data loading in targets dynamically?
sharmahariom
- Jan 18th, 2010
You can use Power Center Monitor. Once you will open property window in monitor you can see dynamic data loading there.
vens28
- Apr 28th, 2009
We can check the target recorded loaded dynamically? by validating the query on target records with time period.1) We need to run the target records related query for? first load with time period an...
-
Mapping Variables
In which senario we need to use parameter file, mapping variables in our mappings?
-
SAP R/3 Data Extraction
How to extract data from SAP R/3 system to a DWH?
ntonsalli
- Feb 12th, 2010
Informatica PowerConnect for SAP R/3 will provide Informatica PowerCenter customers with high-speed data extraction from SAP R/3. Using PowerConnect for SAP R/3, users will be able to access all SAP R...
-
-
-
What is the difference between type 1& type 2 dimension
versionking
- Feb 19th, 2010
Type 1: Update with current data.Type 2: Stores history ie all past and current data.Type 3: Prev data and current data only.
vizaik
- Mar 21st, 2007
There are 3 scd typesscd type1: Only current detailsscd type2: History + current detailsscd type3: Initial + current detailsIn projects, we mainly use scd type1
-
How to load data based on even and odd record numbers
In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and winch transformations we are using?and explain logic?
srinivas jupally
- Feb 22nd, 2010
We can get using mod(Nextval,2) function in expression. After expression use Router transformation.You can connect nextval port from sequence generator transformation.Thanks,Srinivas.J
Informatica Interview Questions
Ans