-
PMF_15001 Failed to write to file error
The reason behind the failure of session is PMF_15001 Failed to write to file there may not be enough space left on the device.Means there is some problem in cache directory space.Please suggest me how I can handle this situation without increasing the disk space.
-
-
Calculate max value of a column
How to calculate max value of a column without using aggregrator transformation?
dihydrox
- Dec 6th, 2008
If you just need to get the max value by the end of session (to increment a value or put at the bottom of a flat file ) you can do the following. Let's say you need to find the max value f...
jryan999
- Sep 1st, 2008
You need to feed your ports through an Aggregator Tranformation. eg.Input = salary. Not outputOutput = maximum_salary --> max(salary) - OutputConnect the maximum_salary fields to ...
-
Target Load Order
Explain What is Target Load Order?
superhero
- Dec 5th, 2008
If you have two source qualifiers and two targets(eg:SQ1,SQ2 and TGT1,TGT2), to decide which target you need to load first, we are using this option.eg: if you want to load first tgt2 after that tgt1,...
prashastha
- Nov 12th, 2008
If you have a multiple sources connected with the multiple targets, then you can specify the order in which target loads data first.
-
What is the use of transformations in informatica mapping for particular target port?
Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
superhero
- Dec 5th, 2008
Edit the transformation and open transformation laguage reference in informatica and observe what are the functions they used and how those will work.
surender7383
- Jul 17th, 2006
we use transformations to convert the input data from source to desired output data for target.but what do u mean by understanding the transformations?
-
What are the Repository types in Informatica PC 6.1 onwards.
superhero
- Dec 5th, 2008
Local---------->versioned,non-versionedglobal--------->versioned,non-versioned
adilshariff
- Jul 1st, 2008
There are two types1.GDR and LDR2.Versioned and NonVersionedWe can use them in combinations, meaningGDR [Versioned/Non Versioned[Default]]LDR [Versioned/Non Versioned[Default]
-
Where do you set target load plan
prasunnesu
- Dec 1st, 2008
The target load plan is required when you have more than one target and you want to set the priorities for the load. Steps to use this. Open the mapping> click on Mapping Tab> target load plan&g...
-
Regression Equation
What do you understand by the linearity in a regression equation?
-
What r the settiings that u use to cofigure the joiner transformation?
Master and detail source Type of join Condition of the join
ORAINFO
- Nov 20th, 2008
There are number of properties that you use to configure a joiner transformation are: 1) CASE SENSITIVE STRING COMPARISON: To join the string based on the case sensitive basis. 2) WORKING DIRECT...
sithusithu
- Jan 20th, 2006
Master and detail source Type of join Condition of the join the Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full OuterCheers,Sithu
-
What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and how informatica handles them?
ORAINFO
- Nov 18th, 2008
Metadata means data about data. Metadata extension means any additional information about the data. For Example let us consider a source qualifier and then I want to put any extra info about it like d...
prabhat007
- Dec 8th, 2007
Metadata Extensions: Who created,what purpose,version number etc for future enhancements. Information about mapping for other people to better understand.Metadata information in repository can be reported using informatica metadata tool.
-
What is Target Update Override? What is the Use ?
ORAINFO
- Nov 18th, 2008
The Integration Service updates target tables based on key values. However, you can override the default UPDATE statement for each target in a mapping. You might want to update the target based on non...
miteshcpatel
- Sep 12th, 2008
When we don't have primary keys defined on database level. And still we need update on this target from Informatica. We neeed to define keys at informatica level and use update override in target property. This way we can update the table.
-
Sorting Data in SQ and SRT Transformation
What is the difference between sorting data in SQ and SRT transformation?
prashastha
- Nov 12th, 2008
The difference for sorting the data in source qualifier and sorter transformation is that:If your source is relation then you can sort the data in both both transformation.But your source is file then you can only sort those data in Sorter transformation.regards....Prabhu S
-
Tracking Hisroty Data
How can we track history DTA without using Lookup Transformation?
prashastha
- Nov 12th, 2008
Yes it is possible, you can use joiner transformation insted of lookup.In joiner you specify the outer join as source and load the data. regards...Prabhu S
-
How to create a TIME DIMENSION in the Target Database(Oracle)?
There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?
arun.menon
- Oct 24th, 2008
Time and Date dimensions are static dimension. Those are one time activity to populate these tables. It is just the naming convetion used across the projects. If you observe these tables, it will have...
Motilal
- Jun 30th, 2006
Hi Jagadeesh,Can you please mail me with the answer of calling the stored procedure for time dimension.And can have the procedure for time dimension in Oracle..?
-
How to test a Case in Informatica?
mike_in_chicago
- Oct 21st, 2008
I think you want a router transformation... This way you can test if input(s) meet a needed criterion and "route" the records that do to correct targets.In Expression transformation you can test case with nested IIF statements in an expression...
-
Merge Two Tables
How to merge two tables or files at workflow level?
-
Upgrading the mappings from Informatica 7.1.3 to Informatica 8
What are the advantages and disadvantages (if any) of upgrading the mappings from Informatica 7.1.3 to Informatica 8
raj_infadev
- Oct 13th, 2008
hi thereits not the matter of advantages or disadvantages for upgrading. its all depends on client requirement. if the client feel that using higer version is more comfortable and ease of use and...
-
Where should you place the flat file to import the flat file definition to the designer?
vishal taywade
- Sep 22nd, 2008
We can place source file any where in network, but it will consume more time to fetch data from source file, but if the source file is present on server srcfile then it will fetch data from source upto 25 times faster than previous.
abhishek_upadhyay
- Sep 18th, 2008
Basically the flat file should be stored in the src folder in the informatica server folder.Now logically it should pick up the file from any location but it gives an error of invalid identifier or no...
-
VB script on Informatica
How can we call a VB script on Informatica.
-
Mapping Parameters
How can we use mapping parameters?
naidubava
- Sep 17th, 2008
Mapping Parameters: Mapping parameter is a constant value which points to any datatype in the entire mapping. its value will not be changed as earlier said. Mapping variable: Mapping variable is same ...
Informatica Interview Questions
Ans