vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

Used in oracle to simplify queriesex: select rowid from (select ename from emp group by sal) where rowid<2

Hanu Ch Rao

• Feb 22nd, 2007

The inline view is a construct in Oracle SQL where you can place a query in the SQL FROM, clause, just as if the query was a table name.A common use for in-line views in Oracle SQL is to simplify complex queries by removing join operations and condensing several separate queries into a single query

Answer Question  Select Best Answer

Can any one tell me the option between the two session . if previous session execute successfully than run the next session...

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

you can drag and drop more than one session in a workflow.there will be linking different and issequential linkingconcurrent linkingin sequential linking, you can run which ever session you require or...

chsrikanth15

• Mar 2nd, 2007

Where exactly do we need to use?this link condition (id $ PrevTaskStatus = SUCCESSFULL)

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

First load manager starts the session and it performs verifications and validations about variables and manages post session tasks such as mail. then it creates DTM process.this DTM inturn create...

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

The PowerCenter Server holds two different values for a mapping variable during a session run: Start value of a mapping variable Current value of a mapping variable Start Value The start value is the ...

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

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 22nd, 2007

Mr.,Go to source analyzerselect sources tab.select import from databases.it opens a child window which asks for username,password and connection name.there will be a button with '...' you pres...

Answer Question  Select Best Answer

dheena

 Profile Answers by dheena Questions by dheena

• Mar 16th, 2007

Hi! 1) The first thing is 8x was not power centre it was power engine.2) In 8i, custom transformation was also available, it was in both active and passive so they released in 8i

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

Both are two versions.But in Infromatica 8x its possible to integrate java program but Its not possible in Informatica 7x to integrate java programs.

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

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

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

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

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

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

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

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 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

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

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