-
Difference between static cache and dynamic cache
Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.The informatic server inserts rows into...
-
What is the target load order?
U specify the target loadorder based on source qualifiers in a maping.If u have the multiple source qualifiers connected to the multiple targets,U can designatethe order in which informatica server loads data into the targets.
-
-
What is IQD file?
sathyanath.gopi
- Feb 27th, 2006
IQD file is nothing but Impromptu Query Definition.This file used for creating cubes in COGNOS Powerplay Transformer.
sathyanath.gopi
- Feb 27th, 2006
IQD file is nothing but Impromptu Query Definetion,This file is maily used in Cognos Impromptu tool after creating a imr( report) we save the imr as IQD file which is used while creating a cube in power play transformer.In data source type we select Impromptu Query Definetion.
-
How to use mapping parameters and what is their use
madhu sudhan rao
- Feb 18th, 2006
mapping parameters and variables make the use of mappings more flexible.and also it avoids creating of multiple mappings. it helps in adding incremental data.mapping parameters and variables has to cr...
gazulas
- Jan 29th, 2006
in designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source ...
-
What is batch and describe about types of batches?
Grouping of session is known as batch.Batches r two types Sequential: Runs sessions one after the other Concurrent: Runs session at same time. If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another.If u have several independent sessions u can use concurrent batches. Whch runs all the sessions at the same time.
-
How the informatica server increases the session performance through partitioning the source?
For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurently. For XML and file sources,informatica...
-
What is the procedure or steps implementing versioning if you are already in version7.X. Any gotcha\'s or precautions..
gauravkant
- Feb 13th, 2006
Hi,For version control in ETL layer using informatica, first of all after doing anything in your designer mode or workflow manager, do the following steps.....1> First save the changes or new imple...
-
-
Can u copy the session to a different folder or repository?
Yes. By using copy session wizard u can copy a session in a different folder or repository.But that target folder or repository should consists of mapping of that session. If target folder or repository is not having the maping of copying session , u should have to copy that maping first before u copy the session
-
In a filter expression we want to compare one date field with a db2 system field CURRENT DATE.Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator)..Can someone help us. Thanks
gazulas
- Jan 29th, 2006
The db2 date formate is "yyyymmdd" where as sysdate in oracle will give "dd-mm-yy" so conversion of db2 date formate to local database date formate is compulsary. other wise u will get that type of error
Sitaram Yarlagadda
- Nov 23rd, 2005
Use Sysdate or use to_date for the current date
-
How to create the staging area in your database
Client having database throught that data base u get all sources
kishore
- Jan 29th, 2006
creating of staging tables/area is the work of data modellor/dba.just like " create table ......" the tables will be created. they will have some name to identified as staging like dwc_tmp_asset_eval.tmp-----> indicate temparary tables nothing but staging
Gokulnath_J
- Nov 8th, 2005
A Staging area in a DW is used as a temporary space to hold all the records from the source system. So more or less it should be exact replica of the source systems except for the laod startegy where ...
-
How can u work with remote database in informatica?did u work directly by using remote connections?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source into U r local machine where informatica server resides.If u work directly with remote source the session performance will decreases by passing less amount of data across the network in a particular time....
sithusithu
- Jan 27th, 2006
You can work with remote, But you have to Configure FTPConnection detailsIP addressUser authentication CheersSithu
-
What is the difference between connected and unconnected stored procedures.
sithusithu
- Jan 24th, 2006
Run a stored procedure before or after your session.Unconnected Run a stored procedure once during your mapping, such as pre- or post-session.Unconnected Run a stored procedure every time a ...
sangeetha
- Sep 26th, 2005
Unconnected:The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another t...
-
What r the tasks that source qualifier performs?
Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join specify sorted records. Select only distinct values from the source. Creating custom query to issue a special SELECT statement for the informatica server to read source data.
sithusithu
- Jan 24th, 2006
Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier. Filter records when the Info...
-
What r the types of groups in Router transformation?
Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups User defined groups Default group U can not modify or delete default groups.
sithusithu
- Jan 23rd, 2006
A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output ports for...
phani
- Dec 9th, 2005
Input group contains the data which is coming from the source.We can create as many user-defined groups as required for each condition we want to specify.Default group contains all the rows of data that doesn't satisfy the condition of any group.
-
Briefly explian the Versioning Concept in Power Center 7.1.
sithusithu
- Jan 19th, 2006
When you create a version of a folder referenced by shortcuts, all shortcuts continue to reference their original object in the original version. They do not automatically update to the current folder...
sri
- Nov 29th, 2005
Hi manoj,I appreciate ur response ,But can u be a bit clearthankssri
-
What r the methods for creating reusable transforamtions?
Two methods 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation. Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time. If u change the properties of a reusable transformation in...
sithusithu
- Jan 19th, 2006
You can design using 2 methodsusing transformation developercreate normal one and promote it to reusable CheersSithu
Praveen Vasudev
- Sep 12th, 2005
PLEASE THINK TWICE BEFORE YOU POST AN ANSWER.Answer: Two methods 1.Design it in the transformation developer. by default its a reusable transform.2.Promote a standard transformation from the mapping d...
-
What is power center repository?
The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, you can create a single global repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
sithusithu
- Jan 19th, 2006
Standalone repository. A repository that functions individually, unrelated and unconnected to other repositories. Global repository. (PowerCenter only.) The centralized repository in a domain, a group...
-
What r the types of metadata that stores in repository?
Following r the types of metadata that stores in the repository Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches Short cuts Source definitions Target defintions Transformations
sithusithu
- Jan 19th, 2006
Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target da...
Informatica Interview Questions
Ans