Prasad P

• Jun 11th, 2007

You can join that table which you wanted to use in lookup in the source qualifier using SQL override to avoid using lookup transformation

muzamil

• Aug 2nd, 2006

 You can use joiner in place of lookup

Answer Question  Select Best Answer

rma

• Dec 1st, 2006

Fact table will contains metrics and FK's corresponding to the Dimesional table, but factless Fact table will contains only FK's of corresponding dimensions without any metrics,regards, rma

srinivas vadlakonda

• Oct 11th, 2006

transaction can occur  without the measure then it is factless fact table or coverage tablefor example product samples 

Answer Question  Select Best Answer

senthilkar

 Profile Answers by senthilkar Questions by senthilkar

• Jan 22nd, 2008

1. Regular Fact - With numeric values2.Factless Fact - Without numeric values

shiva

• Oct 30th, 2006

haithere r three types of factsAdditive Fact-Fact which is used across all dimensionssemi Additive Fact- Fact which is used some dimesion and not with some Non Additive Fact- Fact which is not used any of the dimesion

Answer Question  Select Best Answer

Informatica_buddy

• Nov 10th, 2006

If you want single lookup values to be used in multiple target tables this can be done !!!For this we can  use Unconnected lookup and can collect the values from source table in any target table depending upon the business rule ...   

srinivas vadlakonda

• Oct 11th, 2006

just we can create the view by using two table then we can take that view as lookup table

Answer Question  Select Best Answer

Achut Perumbala

• Jan 9th, 2007

Even i encountered the same issue and i did to following to resolve the issue:1. First Delete the Server from Workflow manager.2. Configure the Server Again and give ur IP while configuring and resolv...

rajani

• Oct 10th, 2006

1. IF you have both Informatica server and client installed on same machine then first turnoff any anti-virus software running, turnoff internet connection.2. Check the settings in workflow server and try again.I hope it resolves your problem.

Answer Question  Select Best Answer

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

Go to the mapping designer check the source username, after that go to session task double click on it go to mapping tab, check the source connection if the name that is mentioned in this tab is not same as the user name what you have used as source change it to that.

sathishkumar_sundaram

• Nov 7th, 2006

Hi,If you look at the last few lines of the error message,ORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database usin...

Answer Question  Select Best Answer

mahindra

• Oct 31st, 2007

Hi,The solution provided is correct. I would like to add more information into it.Reusable Sequence Generator is a must for a Mapplet:Mapplet is basically to reuse a mapping as such if a non- reusable...

PHILIP

• Jun 11th, 2007

Hi Question is, Are you sure its going to start with the 1000 number after the 999. By default for reusable SEQUENCE, it has a cache value set to 1000, that's why it takes 1000 else if you only have 5...

Answer Question  Select Best Answer

How to import a .xls as source into informatica.I want to import the data from two columns of a .xls sheet.

greatvaiz

 Profile Answers by greatvaiz Questions by greatvaiz

• Jul 19th, 2008

1. Go to excel you wnat to inport and select the area where the data is present.2. Go to insert,name,define and define the area3. Create ODBC for excel file.4. Using the created ODBC select the to exa...

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 26th, 2007

Hi there!Just want to add some...  you can use content master and tgp to convert the xls file to xml file. then you can use UDO transformation, XML Parser transformation.  Basically the objective here is to convert the XLS file to XML.

Answer Question  Select Best Answer

sambawipro

 Profile Answers by sambawipro Questions by sambawipro

• Feb 16th, 2007

The Load Manager performs the following tasks: -Manages session, worklet and workflow scheduling-Locks the session and reads session properties-Reads the parameter file-Expands the server and session ...

rma

• Dec 26th, 2006

Load Manager is the Power center process, it performs the following tasksLocks the session and read session properties,read parameter filecreate session log fileverify permissions and previligesit will start the DTM Regards,rma

Answer Question  Select Best Answer

Aparna

• Mar 15th, 2007

If we use Type 2 of slowly changing dimensions we can delete staging area. because SCD Type 2 stores previous data with version number and time stamp.

pushpam vaidya

• Nov 28th, 2006

if staging area is storing only incremental data ( means changed or new data with respect to previous load) then you can truncate the staging area. But if you maintain historical information in staging area then you can not truncate your staging area.

Answer Question  Select Best Answer

Sree.nivas

 Profile Answers by Sree.nivas Questions by Sree.nivas

• Oct 1st, 2007

If we  use same sequence generator for multiple times to load the data at same time there will be DEAD LLOCK occurs.To avoid  Dead locks we dont use same sequence generator

Rich

• Nov 17th, 2006

You can use sequence generator,but is the usein the mapping,it create not unique value

Answer Question  Select Best Answer

Can any one give me the query to delete duplicate records from a table. not selection of duplicates deletion of duplicate records. sql query only

sunil saini

• Feb 27th, 2007

Delete from where rowid in(select rowid from group by all column name)

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 9th, 2007

The query is as undersql>delete from emp where rowid not in(select max(rowid) from emp group by empno);

Answer Question  Select Best Answer

pawarpossible

 Profile Answers by pawarpossible Questions by pawarpossible

• Jul 2nd, 2010

Check which constarint is getting violated in log and take the action accordingly.

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

You have set the session for constraint-based loading, but the PowerCenter Server is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships. Action: Ensure the validity of dependencies between target tables

Answer Question  Select Best Answer

Ajay Kumar Mohanty

• Jan 22nd, 2007

    We are creating a session for the task through task manager

Usha

• Nov 29th, 2006

Normalizer is used to transpose columns to rows and when you are parameterizing.  Informatica power center help is great...

Answer Question  Select Best Answer

siva

• Dec 14th, 2006

This is the informatica file watcher event.

vasu

• Nov 20th, 2006

Thanks ramakrishna. thaks for ur answer & reply

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

DIMENSION means an attribute or characteristic or behaviourDIMENSION TABLE means a table contains different dimensions.

yvreddy

• Dec 30th, 2006

hai,dimension table having more number of attributes(dimension) where as dimension is single attributeyvreddy

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

For relational lookups, you might want to configure the transformation to use a dynamic cache when the target table is also the lookup table. The PowerCenter Server builds the cache when it processes ...

Manisha

• Dec 14th, 2006

Dynamic Lookup is used when the table on which we are performing lookup is being written into. A very common example is when we lookup the Target table to deicde if a particular row is for Insert/upda...

Answer Question  Select Best Answer

Bhargavi

• Dec 6th, 2006

Can u plz explain me about time dimension.

raja147

 Profile Answers by raja147 Questions by raja147

• Dec 4th, 2006

How ? can u explain.

Answer Question  Select Best Answer

toffycoffy

 Profile Answers by toffycoffy Questions by toffycoffy

• Feb 27th, 2007

Just 4 curiosity,  why would u want a cartesian??

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

Create a dummy variable of the type number , default value 0 , in the SQ for Each of  the table and the flat file. Now join the two(table and flat file), with join condition on the dummy variable.

Answer Question  Select Best Answer

Abhijit

• Jan 26th, 2007

Hi,In Static Cache the CACHE ON THE LOOKUP TABLE is built only once - when the 1st row enters the lookup for a comparision.During the whole session the cache stays as it was, hence the name static.In ...

Sravan Kumar

• Dec 20th, 2006

Mainly we have two caches in Lookup transfermations.1.Static cache.2.Dynamic cacheWe can use static cache as connected and Unconnected But dynamic cache is connected only.1.By using Connected Dyn...

Answer Question  Select Best Answer