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

monicageller

 Profile Answers by monicageller Questions by monicageller

• Jan 19th, 2007

Hi Kiran,Can U plz tell  me in detail how do we do that?I am a fresher in informatica...plz help.thanks.

kiran

• Dec 24th, 2006

HiUse strored procedure tranformation to load time dimention

Answer Question  Select Best Answer

The reason behind the failure of session is PMF_15001 Failed to write to file there may not be enough space left on the device.Means there is some problem in cache directory space.Please suggest me how I can handle this situation without increasing the disk space.

superhero

 Profile Answers by superhero Questions by superhero

• Dec 8th, 2008

Remove un used files and folders.

superhero

 Profile Answers by superhero Questions by superhero

• Dec 8th, 2008

Use lookup override Queries to dec the cache size.

Answer Question  Select Best Answer

toffycoffy

 Profile Answers by toffycoffy Questions by toffycoffy

• Feb 27th, 2007

First, u must have proper indexes and the table must be analyzed to gather stats to use the cbo.  u can get free doc from oracle technet.use the hints after and it is powerful so be careful with the hints.

siri

• Feb 14th, 2007

Create indexes for source table colums

Answer Question  Select Best Answer

SRIRAM N

• May 9th, 2007

If you want to run same workflow then schedule it.If you want to run workflow 2 after work flow 1 then, use post session command script to create?a 'successfile.dat' or 'failfile.dat' file in a locat...

dontknow

• Jan 11th, 2007

I am typing this bcos i think this is your question..I think u wanna scheule a second workflow after the success of first workflow ?If this is the Q, Then 1)You can't start second workflow after ...

Answer Question  Select Best Answer

ggk.krishna

 Profile Answers by ggk.krishna Questions by ggk.krishna

• Feb 13th, 2007

Hai ,what Saibabu wrote is correct.Source definition means defining the structure of the source from which we have to extract the data to transform and then load to the target.Target definition means defining the structure of the target (relation table or flat file)

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

source definition is the structure of the source database existed in the OLTP system . using source definition u can extrcact the transactional data from OLTP SYSTEMS.TARGET DEFINITION IS T...

Answer Question  Select Best Answer

Senthilkrishnan

 Profile Answers by Senthilkrishnan Questions by Senthilkrishnan

• Nov 5th, 2009

# Pushdown Optimization Approach# Grid option# Integration Data Quality# Node setup# Java transformation# Dynamic Partitioning

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

Power Center 8 release has "Append to Target file" feature.ava transformation is introduced.User defined functionsMidstream SQL transformation has been added in 8.1.1, not in 8.1.Informatica...

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

U repository server configuration has not done properly.Do check it and proceed.

karthik

• Jan 25th, 2007

Bcoz u r providing in correct host name.

Answer Question  Select Best Answer

mithunmca

 Profile Answers by mithunmca Questions by mithunmca

• Mar 23rd, 2007

hi the below procedure would create a time dimension in oracle --Procedure  to calendar dimension type1, FROM the trancation file.CREATE OR REPLACE PROCEDURE cal_fileis-- Declare a pl/sql table t...

Asha

• Mar 5th, 2007

hi monica,we can create time dimension in 2 different ways1) using Oracle In oracle database, we have to create a procedure...to load the time  and calendar dimension.By just executing EXEC ...

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 5th, 2007

Lookup is using for geta a related value and perform calculation. lookup is using for search value from relational table.

toffycoffy

 Profile Answers by toffycoffy Questions by toffycoffy

• Feb 27th, 2007

The fact that a failed lookup does not erase the row makes it passive.

Answer Question  Select Best Answer