sathishkumar_sundaram

 Profile Answers by sathishkumar_sundaram Questions by sathishkumar_sundaram

• Nov 6th, 2006

Hi,E-R model is Entity Relation model used in Two dimesional Databases.For Example, SQL Server, or Oracle. A table is based on two dimensions.Rows and Columns.Generally, OLTP systems are based on...

Arjun

• Nov 1st, 2006

This is Entity - Relation model which is used for normalising the data

Answer Question  Select Best Answer

MAni

• Nov 7th, 2006

Stop : After issuing stop PCS processes all those records which it got from source qualifier and writes to the target.Abort: It works in the same way as stop but there is a time out period of 60sec.

rkarthikeyan

• May 18th, 2006

Stop:We can Restart the sessionAbort:WE cant restart the session.We should truncate all the pipeline after that start the session

Answer Question  Select Best Answer

sivaprasad

• Nov 7th, 2006

in informatica7.11. we can take flatfile as a target 2.flatfile as lookup table3.dataprofiling&versioning4.union transformation.it works like union all.thanks &regardssivaprasad

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 6th, 2006

load manager is a manager who will take care about the loading process from source to target

Answer Question  Select Best Answer

Neeraj

• Nov 7th, 2006

You can write the query as follows.SQL> select * from 2 (select ename,sal from emp order by sal desc) 3 where rownum

prasad

• Apr 27th, 2006

 the following is the query to find out the top three salariesin ORACLE:--(take emp table)select * from emp e where 3>(select count (*) from emp where e.sal>emp.sal) order by sal desc.in SQL Server:-(take emp table)select top 10 sal from emp

Answer Question  Select Best Answer

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 9th, 2006

Its one kind of report. generally we will use this one in cognos

Answer Question  Select Best Answer

informatica_buddy

• Nov 10th, 2006

You can actually create a view and import it as source in mapping ....

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Sep 23rd, 2006

hifor database procedure we have procedure transmission. we can use that one.thanksmadhu

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

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

I think this question is belongs to congnos.

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Connected stored procedure will execute when each row passed through the mapping then it will execute, Unconnected stored procedure will execute when it is called by the another transformation, and connected stored procedure is the part of a data flow in a pipe line but unconnected is not.

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 15th, 2006

Datawarehouse means it is the repository of integrated information in this OLTP part is there and OLAP part is also there E-R model it is the poor model and it is difficult to understand  and it ...

Answer Question  Select Best Answer

satya

• Nov 16th, 2006

 It is the ability to dynamically re-write SQL to the level of granularity neededto answer a business question

Answer Question  Select Best Answer

raju

• Nov 19th, 2006

I faced this qus in accenture interview

calltomadhu

 Profile Answers by calltomadhu Questions by calltomadhu

• Nov 6th, 2006

Use sqloverride in in source qualifier to get the required columns.

Answer Question  Select Best Answer

srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 24th, 2006

After creating the mapping each mapping can be tested by the developer individualy

raja147

 Profile Answers by raja147 Questions by raja147

• Nov 21st, 2006

Hiutps are done to check the mappings are done according to given business rules.utp is the (unit test plan ) done by deveploper.

Answer Question  Select Best Answer

here are some of the interview questions i could not answer, any body can help giving answers for others also. thanks in advance.Explain grouped cross tab?Explain reference cursorWhat are parallel query's and query hintsWhat is meta data and system catalogWhat is factless fact schemaWhat is confirmed dimensionWhich kind of index is preferred in DWHWhy do we use DSS database for OLAP tools

Pavan Amaraneni

• Nov 24th, 2006

The Default Index type for DWH is bitmap(non-unique)index

Prasad

• Jul 14th, 2006

Hi,Rest of the answers are given by friends earlier.DSS->Decision Support System.The purpose of a DWH is to provide users data through which they can make their critical besiness decisions.DSS data ba...

Answer Question  Select Best Answer

phani

• Nov 29th, 2006

Hi friend,If there is an error comes it stored it on target_table.bad file.The error are in two type1. row-based errors2. column based errorscolumn based errors identified byD-GOOD DATA N-NULL DATA O-...

Answer Question  Select Best Answer

When we are extracting the data from excel sheet. at session level how can we set the database connection for excel sheet?

PooraniAshokkumar

• Nov 29th, 2006

hithis extraction of data can be done in another format alsowhat u can dou can copy the data from excel sheet to a notepad file then u can load the data in the source using import from flatfilethen in...

Answer Question  Select Best Answer

pallavi

• Nov 29th, 2006

Dynamic lookup cache is used in case of connected lookups only, It is also called as read and write cache, when a new record is inserted into the target table, then cache is also updated with the new ...

rma

• Nov 24th, 2006

Dynamic Lookup generally used for connect lkp transformation, when the data is cgenged then is updating, insert or its leave without changing .....

Answer Question  Select Best Answer

PooraniAshokkumar

• Nov 29th, 2006

U might not have done generate and execute sql in target definition just chk it

anand

• Oct 4th, 2006

verify the precession in both sourcsc and tgt  also datatype

Answer Question  Select Best Answer

rma

• Dec 1st, 2006

Mapping is nothing but flow of data from source to Target, we r giving instructions to power center server to move data from source to targets accourding to our business rules, if more business rules r there in our mapping then its copmlex mapping.regards,rma

srinivas

• Sep 14th, 2006

if we are using more business rules or more transformations then it is a complex mapping like SCD type 2(version no,effective date range,flag current date)

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