Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 22nd, 2007

HI Guys just want to clarify, this staging area you are referring to is the actual location of your file and records right ?  This means in unix it could be a folder location like /project/inbox/...

mike

• Feb 8th, 2007

Only 1 staging area. You can use it for extracting, profiling and whatever. Its a bad idea to have individual stating area for each of those operations.Mike

Answer Question  Select Best Answer

Hanu Ch Rao

• Feb 22nd, 2007

The first time you run a session with incremental aggregation enabled, the server process the entire source. At the end of the session, the server stores aggregate data from that session ran in two fi...

Answer Question  Select Best Answer

raj

• Feb 23rd, 2007

We take source data from databae like oracle or any other database .. 1 st we take source data in import option in source section in desginer... ok thanks

Answer Question  Select Best Answer

toffycoffy

 Profile Answers by toffycoffy Questions by toffycoffy

• Feb 27th, 2007

A stored procedure call is made thru an ODBC connection over a network (sometimes the info server resides on the same box as the db)...since there is an overhead in making the call, it is inherently slower.  

Gayathri84

 Profile Answers by Gayathri84 Questions by Gayathri84

• Jan 18th, 2007

Stored Procedures are Hard to maintain and Debug . Maintaince is simpler in Informatica. Its a User friendly tool.Given the Logic. Its eaier to create a Mapping in Informatica than write a Stored Procedure.Thanks,Gayathri

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

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