-
What is a junk dimension
vivek1708
- Jul 30th, 2008
Junk dimensions are particularly useful in Snowflake schema and one of the reasons why snowfalke is preferred over the star schema.There are dimensions that are frequently updated. So from the base se...
ravi kumar guturi
- Mar 10th, 2006
A junk dimension is a used for constrain queary purpose based on text and flag values.Some times a few dimensions discarded in a major dimensions , That time we kept in to one place the all discarded dimensions that is called junk dimensions.
-
What are the steps follow in performance tuning ?
J.David Sukeerthi Kumar
- Nov 26th, 2007
Bottle neck means drawbacks or problems
-
What is a transforamation?
It is a repostitory object that generates,modifies or passes data.
sprajarajan
- Aug 8th, 2008
A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.
bibhu
- Nov 10th, 2006
Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.
-
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
sakthi.jaganathan
- Aug 25th, 2008
The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat file...
Mamta11
- Jul 26th, 2008
Use joiner transformation. If the structure of both the flat files is same you can also use union transformation
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
jryan999
- Sep 1st, 2008
The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either...
subashreddy77
- Apr 27th, 2008
Hiwe can connect as we like but it will be generally based on requirements
-
What is the difference between Enterprise data warehouse and a data warehouse ??Which all transformation uses the cache directory ?
jryan999
- Sep 1st, 2008
I quite agree with the Enterprise Vs Departmental warehouse. Some background through.The two primary warehouse architectures are proposed by Kimball and Inmon. Inmon used to recommend a sin...
Shashikumar
- Jun 21st, 2007
EDW & DW are one & the same. If scope of data warehouse is enterprise wide it is called Enterprise data warehouse.If the scope of data warehouse is limited to department it is called Data mart.Transformation which uses cache are,Lookup,Joiner,Aggregator,Rank
-
Load data from a pdf to a table using informatica.
Can we load data from a pdf to a table using informatica.
adilshariff
- Sep 16th, 2008
Yes, you can load data from a pdf to a table using UDO[Unstructured Data Option] Transformation in Informatica from PC811 onwards
balajirajd
- Jul 26th, 2008
Yes we can load, using stored procedure 1. Need to change pdf to excel /.txt formate.2. Call the procedure in the dummy mapping.
-
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 ...
-
VB script on Informatica
How can we call a VB script on Informatica.
-
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...
-
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...
-
Merge Two Tables
How to merge two tables or files at workflow level?
-
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...
-
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..?
-
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
-
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
-
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.
-
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 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
Informatica Interview Questions
Ans