How the data flows from dimensions to fact table?

wmilford

 Profile Answers by wmilford Questions by 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

 Profile Answers by sameer_solidcore Questions by 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...

Answer Question  Select Best Answer

Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Feb 11th, 2011

Best way is to have a flag in the data to denote it is last row. =Powercenter reads till end of data and it reads in blocks, so it doesn't =expose the state of the last record.

Surya_prakash

 Profile Answers by Surya_prakash Questions by Surya_prakash

• Feb 10th, 2011

Adding index in to source qualifier and drop the index in the target table.

Answer Question  Select Best Answer

rakesh

• May 18th, 2012

TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)

mouni

• Apr 30th, 2012

Ex :to_char(trunc(sysdate),mm)
to_char(date,mm)

Answer Question  Select Best Answer

I have a table having column col1, col2. If for a col1 there is some data in col2.

EX: Col1=0012 and Col2 = 12,13,14

then i need these three values 12, 13,14 separately not as a single string as it is in table. Or you can say in need to separate these three values after it is returned by query.There may be only one value or more than 3 as well.

EX: 12,13,14,15.........

Divya

• Aug 2nd, 2013

I think it can be done with normalizer...
it will end up like

0012 12
0012 13
0012 14

PREETHI

• Dec 7th, 2011

Can you do this in Sybase. For ex: To separate the door nos. alone from a address column.

PREETHI

Answer Question  Select Best Answer

HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...

Gatla Dileep reddy

• Feb 16th, 2015

It is a DB issue, If the Session failed in middle just try to recover the workflow.

Vids

• Aug 13th, 2013

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle databa...

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

Employee name start with A pass to one target,Employee name start with S pass to 2nd target,Employee name start with J pass to 3rd target,other pass to other target.

Sandy

• Aug 31st, 2014

To make current answers generic and mapping applies even if you get more names starting with different characters: Use Sorter, Expression & Transaction control transformations - Using sorter transfor...

amrie

• Jul 30th, 2014

In the expression Create a variable port v_employee= IIF( substr(EMPLOYEENAME,1,1)=A,FLAG1 IIF( SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2, IIF( SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 ))) create a output po...

Answer Question  Select Best Answer

How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table.
Please let me know how can I achieve the above scenario.

Venkateswara Rao

• Oct 14th, 2014

In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Yes, we can. But we need to export/import the mapplet in different repositories. Working with Mapplets: After you create a mapplet, you can validate or edit the mapplet in the Mapplet Designer. You c...

Answer Question  Select Best Answer

How can we receive source as flat file in informatica, from where we get this flat file?

sri

• Jun 18th, 2017

We get flatfile from source to target, which is in file format like MS-Word, etc

Anil

• Jun 22nd, 2016

To explain it clearly we have to know the concept of using FTP. Consider a banking project, the product owner gives all data to production team and not to developer, the 3rd party team gives another d...

Answer Question  Select Best Answer

To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales). Update...

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• May 8th, 2008

Hi The ans to ur question is YesThere are 2 types of lookups: Dynamic and Normal (which you have termed as Static).To configure, just double click on the lookup transformation and go to properties tab...

binoop

• Mar 22nd, 2007

For maintaining the slowly changing diamensions

Answer Question  Select Best Answer

Raja

• Feb 27th, 2007

Regarding transformations:In 7.1We use look up on flat filesthere is union transformation

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

Diffrences of informatica 6.1&7.1

Answer Question  Select Best Answer

superhero

 Profile Answers by superhero Questions by superhero

• Dec 5th, 2008

Local---------->versioned,non-versionedglobal--------->versioned,non-versioned

adilshariff

 Profile Answers by adilshariff Questions by 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]

Answer Question  Select Best Answer

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Yes, its possible using Update override option available for Targets in designer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Sep 3rd, 2009

We can update the target table, by using the update override in target definition. it will update based on non key columns.

Answer Question  Select Best Answer

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

hey kiran,   u can solve this problem by using mapping variable where u need to mention the start value and end value.when u end ur session then that variable will take the next value as the...

abdulla

 Profile Answers by abdulla Questions by abdulla

• Aug 19th, 2006

hi,  u can use mapping variable concept for this.

Answer Question  Select Best Answer

rajvinformatica

 Profile Answers by rajvinformatica Questions by rajvinformatica

• Mar 28th, 2010

I have written as Stored Procedure to get all the Tables from a two Server Server1 and Server2 (parameterized Values) and load them in to two different tables internally through the S.PThis ...

sarita.harsh

 Profile Answers by sarita.harsh Questions by sarita.harsh

• Mar 5th, 2009

Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connecti...

Answer Question  Select Best Answer

satya

• Mar 17th, 2016

Connected Lookup is nothing but it connects to source and target. It can receive multiple inputs returns multiple output.

Unconnected Lookup connects either source or target. It takes multiple inputs but returns single output.

Thank You
Satya

Ketaki Kulkarni

 Profile Answers by Ketaki Kulkarni Questions by Ketaki Kulkarni

• Dec 7th, 2009

Apart from the answers above here is the difference between Static and Dynamic Cache.Static cache is created when the Lookup transformation is encountered for the first time. If this cache is set to b...

Answer Question  Select Best Answer

pallavi

• Nov 6th, 2006

Hi,Lookup is used to look into some other table to get the details for the related information of the current table. These tables have a common column and we get the related information if the condition satisfies.Pallavi

Shravan Gopisetty

• Sep 24th, 2006

We use Look up transfermations to implement the SCD to Implement the CDC(Change Data Capture).The following tasks can be implemented with look up transfermation.1.Get a Related value.2.SCD3.For calcul...

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 14th, 2010

I think this can be done by incremental aggregation at source side and target side

sanjeev

• Aug 6th, 2007

I have one more idea. I think it is right.In source qualifier we have a pre SQL and post SQL. using the pre SQL we can insert 4 and 5 records there.Sanjeev

Answer Question  Select Best Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 11th, 2010

This can be done using SQL query in case of relational sourcesvariables in an expression in case of reltn and flat file srcsIn case of Infa 8.x we have an inbuilt function called MD5 which can be used...

sravan

• Nov 4th, 2006

We can aso use sorter transfermation.seect distinct one check box.

Answer Question  Select Best Answer

sai kiran

• Oct 20th, 2007

If possible using Lookup will give better performance over joiner.Using lookup we can perform?outer joins, equi, and non equi joins.Using joiner we can perform only equi joins.In lookup we can also write SQL ovverrides.

guy.sridhar

 Profile Answers by guy.sridhar Questions by guy.sridhar

• Oct 15th, 2007

The exact difference is, by using joiner we can get both matching and unmatching records from the table .By using look up we can find out whether the records exists or not.and other thing we can ...

Answer Question  Select Best Answer