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

satyakamal

 Profile Answers by satyakamal Questions by satyakamal

• Mar 4th, 2007

22 is the exact number

manju

• Jan 31st, 2007

I checked out its 22 transformation in informatica 7.1.1...pls note dis

Answer Question  Select Best Answer

jithendra

• Mar 6th, 2007

Hi,you can have source left outer joined to target table using the key columns to verify if an incoming row already exists in the target.e.g. consider A as source & B as target. And the key column...

Pradeep

• Mar 3rd, 2007

You could have a SQL override in the Source Qualifier with something like: select * from source_table where not exisits in target_table

Answer Question  Select Best Answer

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

Create a variable port : v_cume_sal=v_cume_sal+amt
output port : o_cume_sal=v_cume_sal

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

In Expression t/r
Create one variable Port v_cum_sal=v_cuma_sal+sal
output port o_cum_sal=v_cum_sal

Answer Question  Select Best Answer

avneeshrathor

 Profile Answers by avneeshrathor Questions by avneeshrathor

• Nov 3rd, 2009

Use target update override and write down your SQL update statement there. It will not require any keys. Before that use whatever to identify which row qualifies for an update and which not.

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

It is true - that it wont work without the keys - dynamic look up and update but if the combination of the columns used for look up always returns a unique value - the update shall still work, even if the keys are not defined.

Answer Question  Select Best Answer

Hi,I am just wondering if there is a direct way to load Excel file into database using Informatica without having to convert Excel to .CSV or XML format. Because we may have to load data from different Excel worksheets.Thanks in AdvanceSrini

Sreedhar Lokaray

• Jul 11th, 2014

We have a separate client tool in Informatica called B2BDT. Earlier it was called as Complex Data Exchange. This tool is used to read data from different sheets of an xls. Not only xls it can be used to read data from pdf, word docs etc.

Manohara Devara

• Jul 3rd, 2012

Hi
Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....

Answer Question  Select Best Answer

in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?

Amritendra kumar

 Profile Answers by Amritendra kumar Questions by Amritendra kumar

• Feb 29th, 2008

As per my openion it will insert only because it give preference to session

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Feb 5th, 2008

It performs insert operation,because session overwrites the mapping level properties

Answer Question  Select Best Answer

What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting.

pal.amol

 Profile Answers by pal.amol Questions by pal.amol

• Mar 1st, 2008

The Data cleaning tool name which is been widely used unliked Informatica (ETL tool ) name is FirstLogic.

Answer Question  Select Best Answer

What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?

nisithm

 Profile Answers by nisithm Questions by nisithm

• Dec 3rd, 2009

PMCMD to run your workflow

gaurav2485

 Profile Answers by gaurav2485 Questions by gaurav2485

• Jan 8th, 2009

We are using Unix in Workflow manager mainly for locating the Source / Target (Flat file) or writing script (if Server is installed in Linux)

Answer Question  Select Best Answer