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

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

For such type of Join we can use INNER JOIN, The best example for this is when we fetch data from a flat file source and the date for which the data has to be fetched is taken from a table known as jo...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 5th, 2010

Dimension table types 1. Slow changing dimensions 2. Junk dimensions 3. Confirmed dimension 4. Degenrated dimension

Answer Question  Select Best Answer

Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?

superhero

 Profile Answers by superhero Questions by superhero

• Dec 5th, 2008

Edit the transformation and open transformation laguage reference in informatica and observe what are the functions they used and how those will work.

surender7383

 Profile Answers by surender7383 Questions by surender7383

• Jul 17th, 2006

we use transformations to convert the input data from source to desired output data for target.but what do u mean by understanding the transformations?

Answer Question  Select Best Answer

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and winch transformations we are using?and explain logic?

srinivas jupally

 Profile Answers by srinivas jupally Questions by srinivas jupally

• Feb 22nd, 2010

We can get using mod(Nextval,2) function in expression. After expression use Router transformation.You can connect nextval port from sequence generator transformation.Thanks,Srinivas.J

prade

 Profile Answers by prade Questions by prade

• Feb 4th, 2009

Use a router on Mod (2)... for 1 route to odds-target and for 0 even-target.

Answer Question  Select Best Answer

h02kkvel

 Profile Answers by h02kkvel Questions by h02kkvel

• May 15th, 2008

Hi all,         some people saying that a union T/R eliminates duplicates. but it is woring . As of now it wont eliminate duplicates.The union T/R is active and...

Ravi

• Sep 25th, 2006

 Hi,     Union also Active tranformation.because it eliminates duplicate rows    When you select distinct option in union properties tab.

Answer Question  Select Best Answer

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

The purpose of using lookup transformation is to check the existing data in target table with the column cust_id after satsifying the condition the rows obtained are used according to your business logic using filter transformation

SRIRAM N

• May 9th, 2007

You should use joiner, then you can use filter if you want, or you can enter the filter condition in joiner as well.

Answer Question  Select Best Answer

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Jan 16th, 2007

Hi,Mapplets is a group of reusable transformations. A mapplet can be called from multiple mappings.A mapping also contain reusable transformations. These transformations could be used in the same mappingRegards

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

mapping is not reusable. mapplet is reusable, mapplet is different set of transformation logic.reusable mapplets we can use in many mappnings

Answer Question  Select Best Answer

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 22nd, 2007

HI Guys just want to clarify, this staging area you are referring to is the actual location of your file and records right ?  This means in unix it could be a folder location like /project/inbox/...

mike

• Feb 8th, 2007

Only 1 staging area. You can use it for extracting, profiling and whatever. Its a bad idea to have individual stating area for each of those operations.Mike

Answer Question  Select Best Answer

Hi, This is Ram working as a system administrator I had installed the Informatica PowerCenter 7.1.1 and when i was configuring the repository server it is giving "the server could not contact" message, I never faced this problem before pls anybody had any solution pls send to me as early as possible i tried all the possible ways to solve this problem but i could not get it so pls help me in this regard.

pal.amol

 Profile Answers by pal.amol Questions by pal.amol

• Feb 25th, 2008

Hi Ram,You could first go to repository manager give relational connection and then you could configure server add new and give details.Give port name as defined in the  configue repository serve...

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

At the time of configuring the repository server just give the port number is 5001 and put a passwordThen start the service first then open the repository server administrator console.Just connect it ...

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

1. Sort based on ename column.
2. in Exp,
Var_Prev=Var_Curr
Var_curr=ename
Var_Value=IIF(Var_Prev=Var_Curr,Var_Value||,||payments,payments)
Out_Value=Var_Value
3. Aggregator transformation: Pull ename,Out_Value ports from Exp in Step 2.
Group by ename

Hope this helps!!!

abraham deng stephen

• Jul 3rd, 2013

Simple use expression transformation and make all the inputs into the date format given. Add a condition like

Code
 

This is my idea. It helps you hopefully....thx

Answer Question  Select Best Answer