-
Import Mapping
How to import mapping from one repository to another repository?
priya.kush
- Jan 9th, 2009
You can use repository manager for the same.Open the repositories drag and drop the mapping from one repository to other.
-
Aggregator transformation
How does sorted input works in aggregator transformation
gaurav2485
- Jan 8th, 2009
Plus when Source data is data driven then Sorted won't effect Performance of aggregator
Vani_AT
- Dec 28th, 2007
Aggregator transformation performance can be improved by using the sorted input option. When you use sorted input, the PC Server assumes all data is sorted by group. As the PC Server reads rows f...
-
Parameter file
How to create parameter file and how to use it in a mapping explain with example
gaurav2485
- Jan 8th, 2009
Suppose we have certain variable or parameter whoes value which change frequently so we will change that value in Parameter file( it is more feasible as no change in Mapping)
sivavin1
- Dec 28th, 2007
Please place your parameter file in the server "srcfiles" with data in it.In mapping designer window of powercenter designer,click on "Mapping" and then "Parameter and variabl...
-
What is difference between source base and target base commit
gaurav2485
- Jan 8th, 2009
Suppose we have choose 10000 source to be commitSource based Commitment is it will read 10000 rows and pass through many transformation (active and passive) so upto what out of 10000 rows it reaches t...
av_ashish
- Oct 17th, 2008
These are the 3 types of commits possible in INFATarget-based commit. The PowerCenter Server commits data based on the number of target rows and the key constraints on the target table. The commit poi...
-
What is granularity in INFORMATICA? How should be the level of granularity for a fact table as well as for a dimension table?
P.Sivakumar
- Sep 12th, 2007
Granularity is a lowest level of information stored in databse that is called as granularity.
-
Cached Lookup and an Uncached Lookup
What is the difference between using a cached lookup and an uncached lookup?
gaurav2485
- Jan 8th, 2009
In Cache Lookup a cache will be created of that Lookup table and IS query once for mapping rows for Uncache lookup No cache will be build and IS query for each Mapping rows.So for performance Go for C...
ggazulas
- May 27th, 2008
For a cached lookup the entire rows (lookup table) will be put in the buffer, and compare these rows with the incomming rows.where as uncached lookup, for every input row the lookup will query the lookup table and get the rows.
-
DTM Buffer Size Default Buffer Blocksize
What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.
gaurav2485
- Jan 8th, 2009
DTM buffer size is memory you allocate?to DTM process (12 MB)Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)And Informatica...
calltomadhu
- Dec 31st, 2008
Hey,workflow manage allocate default of 12MB size to session. you can increase this according to you requirement by specifying them in the form of bytes or you can set to AUTO it will take accordingly...
-
How to import flatfiles from remote location.
venkatasuryadwh
- Dec 16th, 2008
You can do this with the help of?FTP s/w's like Cute FTP s/w from your local desktop to the unix box viceversa.I think this will solve your problem.RegardsVenkat
-
Explain about Incremental Extraction in Informatica
venkatasuryadwh
- Dec 16th, 2008
Use sql overide to capture the change data capture which looks like this..... ( EFF_FROM_DATE >= $$LAST_RUN_DATE AND EFF_FROM_DATE < TO_DATE('$$$SessStartTime'...
-
Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance
superhero
- Dec 12th, 2008
Take two normalizer transformation,pass 1to 81 colomns to N1,81-200 N2.then do the operations in normalizers what ever you want and pass the records from n1- t1 and n2 -t2.
Sharad
- Jan 17th, 2007
Createa a temp stage table, load all the columns in it. The extract all columne from staging table and populate both tgt tables as you want.Cheers.Sharad
-
Convert date format in Informatica
I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has...
superhero
- Dec 8th, 2008
IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')
N SRIRAM K
- Sep 13th, 2007
Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx
-
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...
-
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.
Informatica Interview Questions
Ans