-
What is Meta Data in prospects of Informatica?
DK_Reddy
- Apr 19th, 2009
Informatica Repository Server Holds some data for Mapping transformations and after modifications(Calculations) that data will move to target (as per client requirement)This data will call as Metadata.?
-
How can you create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat...
ASHOK1324
- Apr 18th, 2009
1] Add the metadata of source file into Informatica designer using source analyzer and save source file definition in the repository.2] When we drag the source file definition into warehouse desig...
Latha.
- Sep 3rd, 2007
While creating flatfiles manually, we drag and drop the structure from SQ if the structure we need is the same as of source, for this we need to check-in the source and then drag and drop it into the Flatfile, if not all the columns in the source will be changed as primary keys.
-
Active and Passive Mapplet
What are active mapplet and passive mapplet?
sarita.harsh
- Mar 12th, 2009
A mapplet can be active or passive depending on the transformations in the mapplet. Active mapplets contain one or more active transformations. Passive mapplets contain only passive transformations. W...
-
External procedure transformation and Custom transformation
What is the difference between "external procedure transformation" and "custom transformation"?
sarita.harsh
- Mar 4th, 2009
The input and output functions occur separately in Custom Transformation. In External transformation both input and output? are done by the external procedure function and its parameter consist of a...
phdsong
- Aug 6th, 2008
Both transformations operate in conjunction with procedure your create outside of the Desinger interface to extend PowerCenter functionality. However, for external procedure transformation, you need t...
-
-
-
Data Flow
How the data flows from dimensions to fact table?
wmilford
- Feb 24th, 2009
Data in reality does not flow from dimensions to facts or visa versa. Dimensions contain textual descriptive information in a business unit of an Enterprise. This kind of data is usually contained in ...
sameer_solidcore
- Feb 20th, 2009
In a Data Warehouse Consider there are two tables, D and F, where F is a fact table and D is a dimension table. A dimension table is the one which contains the Primary key and a Fact table is the...
-
How do I import VSAM files from source to target. Do I need a special plugin
Muireadhaigh
- Jan 16th, 2009
PowerExchange does not need to copy your VSAM file to Oracle unless you want to do that. It can do a direct read/write to VSAM.
Muireadhaigh
- Jan 16th, 2009
Yes, you will need PowerExchange. With the product you can read from and write to VSAM. I have used it to read VSAM from one mainframe platform and write to a different platform. Hav...
-
What is confirmed dimension?
bharath
- Mar 2nd, 2007
It is also called as fixed dimension.It is a dimension which doesnot effect with respect to time.for example if the name of the city is changed from bombay to mumbai,the name will not change from time...
-
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
Informatica Interview Questions
Ans