saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

Hisource data exists in OLTP systems of any form (flat file,relational database.,xml definitions.)u can acces the source data with any of the source qualifier transformationsw and normaliser tranaformation.

phani

• Jan 3rd, 2007

Hi,We get souce data in the form of excel files, flat files etc., By using source analyzer we can access the souce data

Answer Question  Select Best Answer

lingesh kumar

• Jan 31st, 2007

Hi U can transfer file from one server to other..............In unix there is an utililty XCOMTCP which transfer file from one server to other. But lot of constraints they are for this..... ...

creativehuang

 Profile Answers by creativehuang Questions by creativehuang

• Jan 8th, 2007

ftp targetaddressgo to your target directoryftp> ascii or binftp> put or get

Answer Question  Select Best Answer

Srinivas Kumar

• Jan 22nd, 2007

I have a good example to explain this . Think about HR Data for a very big Company. The data keep on changing every minute. Now We had build a downstream system to capture a chunk of data for specific...

Sravan Kumar

• Jan 9th, 2007

Source is changing Incrementally means the data in the source is keep on changing and your capturing that changes with time stamps,keyrange and with triggers,scds.Capture these changes to load th...

Answer Question  Select Best Answer

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

hi,scd means 'slowly changing dimentions'since dimention table maintains master data ,the column values occationally changed .so dimention tables are called as scd tables and the fields in the scd ta...

srinivas

• Jan 10th, 2007

Hi,HIRE ,DIMENSIONAL DATA  IS STORED. NO  AGGRIGATE CALCULATIONS SCD WE R USING 3 WAYS1.TYPE-1: IT'S MAINTAIN CURRENT DATA ONY2.TYPE-2: IT'S MAINTAIN CURRENT DATA + COMPLET HOSTROY RECO...

Answer Question  Select Best Answer

manjunathda

 Profile Answers by manjunathda Questions by manjunathda

• Jan 13th, 2007

 An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated...

manjunathda

• Jan 13th, 2007

An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, the contents of the ODS are updated throu...

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

I have two variable ports v1 and v2; v2 is calculated based on v1. What will be the value of v2 for the first time, if the order of ports evaluation is v2 and v1

satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Feb 5th, 2007

The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

Guest

• Feb 5th, 2007

The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

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

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 25th, 2007

Whenever you are using scd2, you have to use dynamic cache, then one port must be specified for updating in cache, that port is called associated port.

kirangvr

 Profile Answers by kirangvr Questions by kirangvr

• Feb 1st, 2007

When you use a dynamic lookup cache, you must associate each lookup/output port with aninput/output port or a sequence ID. The PowerCenter Server uses the data in the associatedport to insert or updat...

Answer Question  Select Best Answer

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

two ways.1. go to navigation panel, under the mapping expand the Transformations folder, will list all the transformation including lookups... 2. but if you want to lookup and browse through only look...

SRIRAM N

• May 17th, 2007

You can have look on all the look-ups that are avialable in a mapping through,???????????? Workflow--> session --> EDIT (and look in MAPPINGS tab)

Answer Question  Select Best Answer

nitin_2002786

 Profile Answers by nitin_2002786 Questions by nitin_2002786

• Jan 24th, 2013

ODBC.ini file has the entry of drivers required for the third party software like sybase, Teradata etc. Its located at server/bin loc.

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Odbc.ini file is used to define the connections(DSN names,tcp/ip port) for database through which Informatica connects to the database.

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• Sep 1st, 2008

I quite agree with the Enterprise Vs Departmental warehouse.  Some background through.The two primary warehouse architectures are proposed by Kimball and Inmon. Inmon used to recommend a sin...

Shashikumar

• Jun 21st, 2007

EDW & DW are one & the same. If scope of data warehouse is enterprise wide it is called Enterprise data warehouse.If the scope of data warehouse is limited to department it is called Data mart.Transformation which uses cache are,Lookup,Joiner,Aggregator,Rank

Answer Question  Select Best Answer

ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?

latha

• May 29th, 2007

Use the Normalizer transformation to take the Mainframe sources(COBOL)

vishnukirank

 Profile Answers by vishnukirank Questions by vishnukirank

• May 26th, 2007

Use Informatica Power Connect to connect to external systems like Mainframes and import the source tables.

Answer Question  Select Best Answer

We can validate all mappings in PowerCenter Repository Manager window by each folder.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 18th, 2014

Please use this link:

http://www.bullraider.com/database/informatica/scenario/27-informatica-scenario19

gives step by step appoach

lakshmi

• May 27th, 2012

in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...

Answer Question  Select Best Answer

Rambabu.Gali

• Nov 27th, 2007

Instead of creating multiple cache files informatica server creates only one cache file for all the lookups used with in the mapping which selected as a shared cache option.

chandrarekha

• Sep 28th, 2007

If you are using single lookup and you are using only for reading tha data you can use satatic cache

Answer Question  Select Best Answer

Venkat

• Sep 10th, 2013

Above answer is not correct.

Correct answer is 150 MB

chandrarekha

• Sep 28th, 2007

10GB

Answer Question  Select Best Answer

sridhar39

 Profile Answers by sridhar39 Questions by sridhar39

• Dec 29th, 2007

hi,     when the informatica server starts a recovery session it reads the            opb_srvr_recovery table and notes the r...

chandrarekha

• Sep 28th, 2007

You have 3 steps in session recoveryIf Informatica server performs? no commit, run the session againAt least one commit, perform recoveryperform recovery is not possible, truncate the target table and run the session again.Rekha

Answer Question  Select Best Answer

Suhel Shaikh

• Apr 4th, 2012

There is no redo log file in informatica.Its in oracle.

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 5th, 2010

Redo log file stores the value only after the" Commit "Transaction Occurs

Answer Question  Select Best Answer

VVM.SP

 Profile Answers by VVM.SP Questions by VVM.SP

• Mar 17th, 2008

It is a intersection table between a dimension table & fact table with a multipart key capturing a many-to-many relationship

venu adavelly

• Sep 18th, 2007

A dim shared by two or more schemas nothing but bridge dim.venu adavelly

Answer Question  Select Best Answer

THEJASWINI

• Sep 1st, 2007

$ - These are the system variables like $Bad file,$input file, $output file, $DB connection$$ - user defined variables$$$ - $$$SessStartTime $$$SessStartTime returns the initial system date value on t...

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Aug 27th, 2007

Generally, As I know. $ refers Session Parameters like $source,$target. $$ refers Mapping Parameters like $$State,$$Time. $$$ refers System Parameters like $$$SessStartTime. I am requesting any other in pool Please check & let me know if I was wrong.

Answer Question  Select Best Answer