sudeep

• Sep 18th, 2015

In general Fact table is normalized and Dimension table is denormalized. So that you will get all required information about the fact by joining the dimension in STAR schema. In some cases where dimensions are bulky then we we snowflake it and make it normailzed.

Niranjan

• Apr 23rd, 2015

Normalization is splitting 1 table to multiple tables to avoid insert/update and delete anomalies. They are done in OLTP systems. De-normalization is exact opposite of normalization, here multiple tab...

Answer Question  Select Best Answer

If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

Anil

• Jun 22nd, 2016

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

Anupam Kumar

• Apr 8th, 2016

Use Router. Create two group and just put TRUE in both

Answer Question  Select Best Answer

jyothi

• Jul 24th, 2012

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

prashant

• Sep 3rd, 2011

Main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

Answer Question  Select Best Answer

Hi,Can Informatica power center 7.1.1 installed on Windows vista home premium? If so how to install informatica server and repository server?Thank you,Vamshi.

anithashriya

 Profile Answers by anithashriya Questions by anithashriya

• Dec 22nd, 2007

But i could not find an option windows xp service pack 2 after right clicking on setup.exe of informatica powercenter 7.1.1, still the error is continuing if i try to execute setup.exe ...can anyone come up with the solution

Pallavi50953

 Profile Answers by Pallavi50953 Questions by Pallavi50953

• Dec 21st, 2007

Hi,   I installed informatica powercenter 7.1 in my laptop and i can even open repository server console.   But now for connecting to the repository it is asking for a password.Can any one specify which port and password should i specify for connecting to the repository.

Answer Question  Select Best Answer

Santosh

• Dec 26th, 2011

In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

suren

• Nov 22nd, 2011

Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

By using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jun 11th, 2012

Hi Shiva,

You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.

Answer Question  Select Best Answer

Sharmila

• Mar 5th, 2016

We can validate all mappings at a time which are in a single folder level in Repository. Steps to follow: In power center Designer: Goto Tools => Queries 1. Create "New" Query in Query browser 2. Q...

swaroopkanth

• Feb 8th, 2012

We can validate all the mappings in the repository at once. This is possible through the repository manager.

Answer Question  Select Best Answer

It represents all data queried from the source.

Read Best Answer

Editorial / Best Answer

sprajarajan  

 Profile Answers by sprajarajan Questions by sprajarajan

• Member Since Mar-2008 | Aug 8th, 2008

---

Source Qualifier Is the default Transformation.
Through The source Qualifier Transformation Informatica Reads The Data.
We can Filter The Data.
We can sort the Data.
Its also Used to Join Homogeneous Source systems.
We can Join Any number of Sources in Singlae Source Qualifier.
We Can't Join the Flatfiles In sourcequalifier Because Flatfiles Are Heterogeneous When we open the Flatfiles At sourcequalifier At the time All The options are Disabled.

joyfun23

 Profile Answers by joyfun23 Questions by joyfun23

• Jan 26th, 2010

1. Source Qualifier is the most important transformation which convert the source data type in to compatible NATIVE datatype of a mapping.2. Without a SQ a mapping can not be created,?after extractio...

venkat224

 Profile Answers by venkat224 Questions by venkat224

• Dec 24th, 2009

Source Qualifier is one of the transformations, which converts any type of data to the relational format. So that, can easily be used for any of the operations on the data.

Improve Answer

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

Yes, We can!

Open the folder where the reusable transformation is existing.

Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.

Now you have non reusable version of your reusable transformation.

Thanks

Bibhu

• Jul 4th, 2014

Yes, we can. It can be done in the transformation developer.

Answer Question  Select Best Answer

What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.

Amar

• Nov 30th, 2012

The main logical difference is that we use connected lookup while loading dimensions and unconnected look up while loading facts

ASHU

• Jan 21st, 2012

A Dimension table contain descriptive (detailed) data and a fact table contain measurements (facts) which are used to evaluate a business, all numeric are not a facts but the numeric which are key performance indicators is known as facts.. fact table contain summarized data....

ASHU (KARIMNAGAR)

Answer Question  Select Best Answer

In which situation do we use update strategy?

Anil

• Jun 22nd, 2016

If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr. If we want to perform 2 DML...

ankit

• May 4th, 2016

Can any one tell me in which scenario it is not advisable to use update strategy?

Answer Question  Select Best Answer

Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?

Read Best Answer

Editorial / Best Answer

sasi.a.kumar  

 Profile Answers by sasi.a.kumar Questions by sasi.a.kumar

• Member Since Aug-2009 | Aug 14th, 2009

---

Router is an Active Transformation, Most of the time we use router only when we are going to apply multiple conditions on a records, It is absolutely possible for a record to satisfy one or more conditions thus making the router Active, Router is the only active transformation where the number of?output records from the transformation is greater or equal to the number of input records given to the transformation.

bosna

• Aug 17th, 2011

AS PER INFORMATICA DOCUMENTATION, Router transformation is ACTIVE and CONNECTED.. Please Don't thumb down if you're not sure..

RANJAN RASMI DAS

 Profile Answers by RANJAN RASMI DAS Questions by RANJAN RASMI DAS

• Jan 12th, 2011

Router can act both active and passive, one example....Suppose in source we have recordsid.....name -----------10.....aa10.....bb20.....cc20.....dd30.....xx40.....yy We have one target table...

Improve Answer

What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?

Read Best Answer

Editorial / Best Answer

anshu.gangwar  

 Profile Answers by anshu.gangwar Questions by anshu.gangwar

• Member Since Sep-2008 | Sep 30th, 2008

---

$ prefixes are used to denote  session Parameter and variables and $$ prefixes are used to denote mapping parameters and variables

SEHAJ

• Aug 18th, 2011

$-This is d symbol for server o inbuilt variable.

$$-this is the symbol for the variables o parameters which v create

sweetmann27

 Profile Answers by sweetmann27 Questions by sweetmann27

• Aug 10th, 2011

Hi,

$ is session parameter e.g $DBConnection
$$ is mapping parameter/variable e.g $$LASTRunDate

Thanks

Improve Answer

Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first and last) should not be populated.When the workflow runs for the third time only the third target...

sum

• Oct 8th, 2015

Define one variable $$CNT in mapping and assign its initial value as 1 in parameter file Take an expression and do below coding count =$$CNT INC_COUNT=$$CNT+1 O_INC_CNT=SETVARIABLE($$CNT,INC_COUNT) Ad...

Rakesh

• Feb 9th, 2015

your above logic is perfect..but instead resting the variable at workflow level you can add these condition in first router group => MOD(o_Flag,3) = 1 2nd router group =>MOD(o_Flag,3) = 2 3rd router g...

Answer Question  Select Best Answer

how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisalthanksvenu

milind

• Aug 6th, 2015

Yes dummy column will work
other way is to use mapping variable :)

ashish

• Sep 27th, 2014

You can create a dummy port in each source and assign 1 to both port and drag the both sources in joiner tr and give join condition on dummy port, After that you can use filter condition on your location

Answer Question  Select Best Answer

set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.

Read Best Answer

Editorial / Best Answer

ManishTewatia  

 Profile Answers by ManishTewatia Questions by ManishTewatia

• Member Since Jul-2010 | Jul 22nd, 2010

---

What Md.Rehman is trying to say is catagorizing the SCD which are the Slowly Changing Dimensions which are used to maintain historical data.

Dimension:A dimension is an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tables

The various types of dimensions are :

1) Shared and Private Dimensions: Describes the basic differences between shared and private dimensions and their uses

2) Regular Dimensions: Provides information about regular dimensions and their variations

3) Parent-Child Dimensions: Describes the creation of parent-child dimensions and identifies their advantages and restrictions

4) Data Mining Dimensions: Describes the creation of data mining dimensions and identifies advantages and restrictions to their use

5) Virtual Dimensions:Describes the creation of virtual dimensions and their advantages and restrictions

6) Dependent Dimensions: Describes the creation of dependent dimensions and identifies their advantages and restrictions

7) Write-Enabled Dimensions: Describes the creation of write-enabled dimensions and identifies their advantages and restrictions

VIKRAM KUMAR

• Mar 1st, 2018

Dimensions are of several types but we use few commonly which are, 1. Confirmed dim. dim. shared by all fact tables. ex- time dim. 2. Slow changing dim. it is of 3 types : SCD1. SCD2, SCD3., 3. Role ...

Venu Gaddam

 Profile Answers by Venu Gaddam Questions by Venu Gaddam

• Dec 23rd, 2010

Dimensions are of 3 types mainly in case of slowly changing dimensions: Type 1 -> Does not maintain any history and is update only. --> this is normal practice mappings.Type 2-> Maintains full histor...

Improve Answer

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh

k.praveenkumar

• Dec 6th, 2011

Software could be corrupted or has attacked with Virus,
Re-install and if the problem persist then you change the OS and try Informatica, it may work.

Srikanta

• Nov 11th, 2011

In order to up your IRS, please follow up the guidelines:- 1) Create a database, if u have already DB exist, then u can go with the same. 2) Create two db users, give admin privilege to those users....

Answer Question  Select Best Answer