vishal

• Feb 16th, 2007

We use sql override for 3 transformationswhen the source is homo genious1. joiner transformation2. filter transformaton3. sorter transformation

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

Besides the answers above, in Session properties -> transformations tab -> source qualifier ->SQL query - by default it will be the query from the mapping.  If you over write it, this is also called 'SQL override' 

Answer Question  Select Best Answer

sambawipro

 Profile Answers by sambawipro Questions by sambawipro

• Feb 16th, 2007

The Load Manager performs the following tasks: -Manages session, worklet and workflow scheduling-Locks the session and reads session properties-Reads the parameter file-Expands the server and session ...

rma

• Dec 26th, 2006

Load Manager is the Power center process, it performs the following tasksLocks the session and read session properties,read parameter filecreate session log fileverify permissions and previligesit will start the DTM Regards,rma

Answer Question  Select Best Answer

sai

• Feb 14th, 2007

Hi here is the answer
select * from t_name where rowid in (select rowid from t_name group by empno having count(*) =3);

chandra_rn

• Feb 7th, 2007

I think this is query select * from emp where rowid > select max(rowid) from emp group by eno,ename

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

ERP stands for Enterprise resource Planning for business developments and maintenance.Each and every database to store the organisation data is known as ERP.

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

Staging database is the storage area of data. it does cleans the data, transform,combine and prepare the source data to the data mart area or data ware house.

manju

• Jan 12th, 2007

Staging database is the storage area. it clean the data, transform,combine and prepare  the source data to the data mart or data ware house. staging area is in b/w the source database  ...

Answer Question  Select Best Answer

ggk.krishna

 Profile Answers by ggk.krishna Questions by ggk.krishna

• Feb 13th, 2007

Hai ,what Saibabu wrote is correct.Source definition means defining the structure of the source from which we have to extract the data to transform and then load to the target.Target definition means defining the structure of the target (relation table or flat file)

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 11th, 2007

source definition is the structure of the source database existed in the OLTP system . using source definition u can extrcact the transactional data from OLTP SYSTEMS.TARGET DEFINITION IS T...

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

Yes any user can run the wizard if its under the administrator group.

Ajay Kumar Mohanty

• Jan 22nd, 2007

Yes the created user can run the wizard if its under administrator group with the publics

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

Look of transformation we r using to tally the records of source and target.The main things r as under1.To get the related values between source and target.2.Used for caluculation purposes.3.Slowly changing dimensions.

sivaprasad

• Dec 4th, 2006

the main uses of lookup transformation is:1.get the related values2.used for caluculations3.slowly changing dimensions

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

U repository server configuration has not done properly.Do check it and proceed.

karthik

• Jan 25th, 2007

Bcoz u r providing in correct host name.

Answer Question  Select Best Answer

sandrag

 Profile Answers by sandrag Questions by sandrag

• Feb 7th, 2007

The SQL override works first when compared to any other means of conditions used in the source qualifier.

Satish

• Dec 6th, 2006

Well Sql over ride wud execute... it wud over ride wht ever condition in the mapping......................................

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

sandeep

• Feb 2nd, 2007

Install informatica server side 1st then at time of installation create repository and integration service, you can create repository and integration service after installation install client side, c...

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

Lingesh Kumar

• Jan 31st, 2007

Hi When ever you load to source load with date timesatmp. Suppose u want ot today records into target table. So source table will have today Date timestamp for all the records which came toda...

jvivek80

• Dec 25th, 2006

Five methods for capturing data changes are available:Use source timestamps. -- Advances in operating systems and RDBMS functionality has enabled us to a large extent to identify record creation and ...

Answer Question  Select Best Answer

Lingesh kumar

• Jan 31st, 2007

Hi, Generally any mapping is run from UNIX i..e UNIX shell script calls work flow.work flow intern calls mapping. Suppose i am generating a flat file in unix from informatica mapping,if i nee...

Answer Question  Select Best Answer

Abhijit

• Jan 26th, 2007

Hi,In Static Cache the CACHE ON THE LOOKUP TABLE is built only once - when the 1st row enters the lookup for a comparision.During the whole session the cache stays as it was, hence the name static.In ...

Sravan Kumar

• Dec 20th, 2006

Mainly we have two caches in Lookup transfermations.1.Static cache.2.Dynamic cacheWe can use static cache as connected and Unconnected But dynamic cache is connected only.1.By using Connected Dyn...

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

You cannot install informatica using the same CD that used for windows. You need to have a separate licence key for unix. Install process is quite simples , only you need to run the file called inst...

sri

• Sep 5th, 2006

you need seperate licence key for unix.I dont think windows licenese key works for UNIX.srihari_t@yahoo.com

Answer Question  Select Best Answer

sidhu

• Jan 25th, 2007

No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it...


Sidhu

jagadeesh

• Apr 3rd, 2006

No GUI mode in unix till now.....Only command prompt will help in unix environment for pmrep and pmcmdfrom Jagadeesh

Answer Question  Select Best Answer

anu

• Jan 25th, 2007

Are you lookuping flat file or database table? Generaly, sorted joiner is more effective on flat files than lookup, because sorted joiner uses merge join and cashes less rows. Lookup cashes always who...

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