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

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

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

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

ravi

• Mar 1st, 2007

Direct mode means when you are loading a flat file. Indirect mode means when you are loading list of files having same property.

pal

• Feb 9th, 2007

Indirect and direct mode in session properities are related to flat file.If you are giving the flat file name directly then it is direct mode.If you have 2 or more files where data is present and you ...

Answer Question  Select Best Answer

sanghala

 Profile Answers by sanghala Questions by sanghala

• Mar 1st, 2007

Scheduling of Informatica jobs can be done by the following ways:Informatica Workflow MangerUsing Cron in UnixUsing Opcon sheduler

Answer Question  Select Best Answer

anju

• Mar 2nd, 2007

In ODS there is no historic data. ODS holds data temporarily. ie for reporting purpose.

MANOJ KUMARPANIGRAHI

• Feb 21st, 2007

ODS(opertional data store) It is part of the data warehouse architecture. It is the first stop for the data on its way to the warehouse. It is here where I can collect and integrate the data. I can en...

Answer Question  Select Best Answer

Hanu Ch rao

• Mar 2nd, 2007

Hi,You can override any property like pre-session, post-session and SQL query in SQT and like any other trans in the mapping except SGT (sequence Generator Trans) You cannot overide the properties of SGT in session level.

sm1506

• Apr 7th, 2006

1) I want to Know which mapping properties can be overridden on a Session Task level.You can override any properties other than the source and targets. Make sure the source and targets exists in ur db...

Answer Question  Select Best Answer

Hanu Ch Rao

• Mar 2nd, 2007

I was asked this question in an interview,Where did you implement SCD2 and what was the transformations used.What was the complex transformations did you use.Answers please........?u can implement SCD...

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

SCD IS USING FOR MAINTAIN HISTORICAL DATA AND CURRENT DATAEX: EMP TABLE WE CAN MAINTAIN CUSTOMER ADDRESS, AFTER ONE YEAR CUSTOMER ADDRESS IS CHANGED. SCD MAINTAINS CURRENT ADDRESS AND OLD ADDRESS ALSO...

Answer Question  Select Best Answer

satyakamal

 Profile Answers by satyakamal Questions by satyakamal

• Mar 4th, 2007

22 is the exact number

manju

• Jan 31st, 2007

I checked out its 22 transformation in informatica 7.1.1...pls note dis

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

jithendra

• Mar 6th, 2007

Hi,you can have source left outer joined to target table using the key columns to verify if an incoming row already exists in the target.e.g. consider A as source & B as target. And the key column...

Pradeep

• Mar 3rd, 2007

You could have a SQL override in the Source Qualifier with something like: select * from source_table where not exisits in target_table

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

First u can ask what type of data change columns to rows in informatica?Next we can use expression and aggregator transformation.aggregator is using group by duplicate rows

Hanu Ch Rao

• Mar 2nd, 2007

Hi,We can achieve this by Normalizer trans.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

2004

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

You can identify source bottlenecks by executing the read query directly against the source database. Copy the read query directly from the session log. Execute the query against the source database w...

Answer Question  Select Best Answer

vikki_gupta2003

 Profile Answers by vikki_gupta2003 Questions by vikki_gupta2003

• Mar 14th, 2007

Hi,1)At DB level we can simply DROP the stagin table.2)then Create Target table at DB level.3) Directly LOAD the records into target table.NOTE: It is recommended to use staging area.

Prasad

• Jul 14th, 2006

hi,this question is logically not correct. staging area is just a set of intermediate tables.u can create or maintain these tables in the same database as of ur DWH or in a different DB.These tables w...

Answer Question  Select Best Answer

shravanamsharat

 Profile Answers by shravanamsharat Questions by shravanamsharat

• Mar 15th, 2007

Overwrite the SQL Query at Source Qualifier transformation

hemasundarnalco

 Profile Answers by hemasundarnalco Questions by hemasundarnalco

• Mar 9th, 2007

Write a sql qurey to perform an aggregation in the source qualifier transformation

Answer Question  Select Best Answer

1.How do you store Historical data in a DWH?2.What is the primary purpose of using surrogate key? Will those be used in fact tables?If not then what is the purpose in using it?3. How do you update Information in Update strategy Transformation?4. How do you validate data after you have transferred it into target table from flat files?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 15th, 2007

By using scd2, we can store historical data.Surrogate key is used for indexing purpose.  i.e. as a primary key for a table.  You can say that why can't we use primary key.  But the ...

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 15th, 2007

By using scd2, we can store historical data.Surrogate key is used for indexing purpose.  i.e. as a primary key for a table.  You can say that why can't we use primary key.  But the ...

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