Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

We have Session,Command and Email tasksCheers,Thana

Siddhant Mirji

• Jul 11th, 2007

SessionCommandDecisionEvent WaitEvent raiseEmailTimerAssignmentControlWorklet

Answer Question  Select Best Answer

ramakrishna

• Sep 22nd, 2007

A measurable data on which simple addition can be performed is called fully additive such measurable data's no need to combine two or more dimensions for it's meaningEx: Product wise total salesBr...

murali

• Nov 27th, 2006

Average monthly balance of your bank account is a semi-additive fact.

Answer Question  Select Best Answer

anju

• Mar 2nd, 2007

In ODS there is no historic data. ODS holds data temporarily. ie for reporting purpose.

MANOJ KUMARPANIGRAHI

• Feb 21st, 2007

ODS(opertional data store) It is part of the data warehouse architecture. It is the first stop for the data on its way to the warehouse. It is here where I can collect and integrate the data. I can en...

Answer Question  Select Best Answer

ravikumar.amudala

 Profile Answers by ravikumar.amudala Questions by ravikumar.amudala

• Aug 26th, 2009

Now we dont have that problem, now sequence generator trans is have some around 18 digit number, so the problem is solved.if it extends more than that, go for stored procedure.RegardsRavi

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

use a Stored Procedure transformation where the stored procedure generates keys after checking the max in the target.

Answer Question  Select Best Answer

What is the difference between index cache and data cache

santosh

• Dec 26th, 2011

Index cache : Integration service stores all conditional values in to the index cache and all output values into the data cache.

Please correct me anything wrong

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

If we talk with respect to Aggregate Transformation , then Index Cache stores the Group Values and data Cache stores the Actual Data which is Row data.

Answer Question  Select Best Answer

What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?

Rashmirekha

 Profile Answers by Rashmirekha Questions by Rashmirekha

• Sep 2nd, 2009

For Unsorted Input joiner transformation, i) Data cache stores all master rows in the join condition with unque index keys ii) Index cache stores all master rows.For Sorted Input with Different ...

raam.pt

 Profile Answers by raam.pt Questions by raam.pt

• Aug 18th, 2009

Caches in JTR are 2.
1) Data Cache
2) Index Cache
1) Data Cache: It stores master source rows OS source table as configured in join condition.
2) Index Cache: It stores index values for master.

Answer Question  Select Best Answer

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

Read Best Answer

Editorial / Best Answer

Answered by: purushotham

• Aug 9th, 2005

---

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

amolrenose

 Profile Answers by amolrenose Questions by amolrenose

• Sep 18th, 2011

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer

NO. We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.

CeeJay

• May 30th, 2013

No. It cannot be used in different mappings as when it is saved in the repository, it is saved for a particular mapping. And at global level we have mapping parameters only and not variables which cannot be changed.

Tapas

• Oct 6th, 2007

The scope of a mapping variable is the mapping in which it is defined. A variable Var1 defined in mapping Map1 can only be used in Map1. You cannot use it in another mapping say Map2.

Answer Question  Select Best Answer

pr

• Mar 10th, 2016

Joiner : > It support equiv Join only. > It may be we can perform outer join only. > Joiner is used to source only. > It may be only "=" operator used. > In joiner may be not present in lookup ov...

Nishikant Shekhar

 Profile Answers by Nishikant Shekhar Questions by Nishikant Shekhar

• Jul 22nd, 2009

Lookup transformation is a Passive transformation where as Joiner is Active Transformation.Lookup you can have both connected as well as unconected where as Joiner is always connected.Joiner is used t...

Answer Question  Select Best Answer

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Query hints are used in RDBS concept, when you write SQLs in pervious days developer use give hint points while writing the query for DB engine, they are called rule based DB, now the rule based DB is fading out in the market, these days youwill find all new DBs as cost based

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Aggregate awareness is the method in Business Objects while creating measures in the universe, it is process where you define the aggregation strategy which you wanted BO to follow, useful mostly for Drill downs based on different dimentions

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 9th, 2008

Select business_key,max(version) from tablename group by business_key

ketannp

 Profile Answers by ketannp Questions by ketannp

• Feb 9th, 2008

Select Acct.*,Rank() Over ( partition by ch_key_id order by version desc) as Rankfrom Acctwhere Rank()=1

Answer Question  Select Best Answer

pawan Singh

• Jun 15th, 2013

TWS( Tivoli scheduler)

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 8th, 2010

Yes we can do by using this by third party scheduler by unix script some of the third prty schedules are1.autosys2.control-m3.cron in unix4.pcon scheduler

Answer Question  Select Best Answer

Rupesh Lokhande

• Oct 4th, 2018

1. SQL Override is to limit the number of incoming rows entering the mapping pipeline - Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time ...

sarada

• Nov 28th, 2013

using source qualifier u can extract the data from sources,in over ride u can write the queries to run in the data base,where as in sql t/f u can write and run the queries in database and get the res...

Answer Question  Select Best Answer

rajesh

• Jul 14th, 2011

Using look up we can perform following 1.=,2.,4.=,6.!= also
But joiner 1.=,2.master outer,3.detailed outer,4.full outer

krishna

• Jul 12th, 2011

Lookup Transformation will perform Non_Equi Joins

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Rajsuni  

 Profile Answers by Rajsuni Questions by Rajsuni

• Member Since Apr-2011 | Apr 1st, 2011

---

 Informatica Architecture :
            
   client tools-
                  Repositoy Manager->  Pc Designer->    WFManager->           WFMonitor       
                            |                               |                          |                                |
              (creat,mdify,del-folders,    (src&Tar def,         (create tasks             (display
              privilages& access RS)     mapings,maPlets)connect to work flow) reult/output)
   ---------------------

   Powercenter tools--
                   PC service   <--------------------->Repository Database
                          |
                          |
         <-------> PC Server<---->

here: Pc-PowerCenter.

venkat m

• Sep 20th, 2011

Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 15th, 2011

When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...

Improve Answer

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 13th, 2009

Use following expression in update strategy transformation.iif ( condition 1 , DD_INSERT,  condition 2 , DD_UPDATE,  condition 3 , DD_DELETE,  DD_REJECT -- for default)and set session property as data driven, You can cross check these conditions values during session debug runs.

prade

 Profile Answers by prade Questions by prade

• Jun 26th, 2008

In general DWH scenario, we create TABLE_REJECT or FILE_REJECT to keep a check of the rejected records. For all the updates happening we keep timestamp or some other flag in the database.Before t...

Answer Question  Select Best Answer

Milind Jadhav

• Mar 21st, 2015

Informatica follow input variable n output process.thus you can make some calculations in variable port n copy them to the output port to achieve some purpose mostly used in expression tf

Kameshwara

• Aug 8th, 2013

variable ports are used in transformations like Expression/Aggregator where you can hold a value of incoming data. This can be helpful when you want to check if incoming column value is same or a cha...

Answer Question  Select Best Answer

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Right click on the session in the monitor if its a sequential run and there appears a stop option in the drop down once you stop the session workflow will either gets suspended or failed according to ...

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 5th, 2007

Madhu, Here is the statement to start/stop a session....$PM_HOME/pmcmd starttask -s $PM_PMSERVER_PORT -uv USERNAME -pv PASSWORD -wait -f $Folder -w $Workflow $Task#      ...

Answer Question  Select Best Answer

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions w...

Raja

• Jun 1st, 2007

Dimension Mapping: In any star schema, we need to load all the Dimension tables first, because they act like reference for Fact,Fact mapping: there is dependency for Fact, which looks up for the Dimen...

Answer Question  Select Best Answer

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?

hanimi

 Profile Answers by hanimi Questions by hanimi

• Feb 26th, 2011

Oracle Sequence Generator is faster.

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

To answer precisely functionality of both is same and even both are at par w.r.t to performance but there are certain limitations Oracle sequence generator is a stored procedure which can be call from...

Answer Question  Select Best Answer