crishnathk

 Profile Answers by crishnathk Questions by crishnathk

• Dec 12th, 2006

thq from ur answer i can come to one conclusion tht ODS is used to store the current data.i can assume tht by defalut it will add tht 40000 records to this current data 10000 records n gives the reslut 50000.cud u plz reply to this......thq...

Sravan Gopisetty

• Sep 24th, 2006

ODS is an Integrated view of Operational sources(OLTP).

Answer Question  Select Best Answer

PavaniKatta

 Profile Answers by PavaniKatta Questions by PavaniKatta

• Dec 11th, 2006

Source qualifier transformation is used to extract the data from one or more tables from RDBMS of the same instance or from a single flat file system.Application Source Qualifier transformation is used to extract the data from Application sources like ERP.

Answer Question  Select Best Answer

krishnasri424

 Profile Answers by krishnasri424 Questions by krishnasri424

• Dec 7th, 2006

Use sequence generator and set the 'Increment by' property in that with 2.

Pavan.m

• Dec 7th, 2006

Use sequence generator to generate warehouse keys and set the 'Increment by ' property of sequence genrator to 2.

Answer Question  Select Best Answer

The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount u configure in the transformation or session properties.The informatica server stores condition values in the index cache and output values in the data cache.

Puli Ramesh

• Dec 6th, 2006

A LookUP Cache is a Temporary Memory Area which is Created by the Informatica Server. which stores the Lookup data based on certain Conditions.  The Caches are  of  Three types 1) Persistent 2) Dynamic 3) Static  and 4) Shared Cache.

srinivas vadlakonda

• Sep 28th, 2006

Lookup cache is the temporary memory that is created by the informatica server to hold the lookup data and to perform the lookup conditions

Answer Question  Select Best Answer

Can any one explain about the new port that is created in the lookup after enabling the dynamic lookup cache?and what is the associate port??????thanks in advance for your time

Manasa

• Dec 6th, 2006

A Lookup transformation using a dynamic cache has the following properties: NewLookupRow. The Designer adds this port to a Lookup transformation configured to use a dynamic cache. Indicates with a num...

adil

• Nov 28th, 2006

Hi,Associate port is either an i/p or o/p .Data in this port is used by IS[Infa Server] to insert or update lookup cache.

Answer Question  Select Best Answer

what are all the modes are available for running a session.Can any one Explain in Detail?

Kishan

• Dec 6th, 2006

thq for ur reply....cud plz tell me wher we can use this stored procedure transforamtion,update strategy trnasformation with ex:..waits for ur reply 

UmaBojja

• May 26th, 2006

If u are asking about the mode in which the data is transferred then Informatica supports two modes1.ASCII2.UNICODE

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

Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation. Session : It is a set of instructions that describe how and when to move data from source to targets.

Pavani

• Dec 4th, 2006

Mapping:A set of source and target definitions linked by diffrent transformation  that define the rules for data transformation. Session:A session identifies the mapping created with in the ...

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

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

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

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

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

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

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

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

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

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

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