Answer / krishnam

If the MP or MV is not defined then infa server will take
the default values. The order is: First it will serch in
Parameter file for the values, then repository( in case of
MV), if the value is not found then it will look for
initial value. If it can not find the value it will take
default values.

Answer / reddevilzz

For mapping parameters, there cud be a scenario as below
Lets say I have a sql override as ,
Select emp_no, emp_name from emp where $$Hint1
In parameter file, I have $$Hint1 = dept_id in (1,2)
if $$Hint = <empty>, in parameter file, in this case the
mapping will fail because, SQ would not be able to prepare
the query,

In another scenario, i can have SQ override as
Select emp_no, emp_name from emp $$Hint1
In parameter file, I have $$Hint1 = where dept_id in (1,2)
if $$Hint = <empty>, in parameter file,
still the mapping will be executed.

Answer / santosh

First i will look in PARAMETER FILE
then
2)Value in pre-session variable assignment

then

3)value saved in repository
then

4)Initial value

And

5)Data type default value

Answer / nagaraju bhatraju

If Mapping Parameter or variable is not defined in
parameter file session will fail, but if default value is
defined at , then session will take those default values.

Answer / ashok\

It's does not impact on any thing if you dont use .
If we require then we will go for mapping parameters and
variable.If suppose,we use Mapping Parameters or varaibles
then we must define at mapping level and we should give
parameter file name and path at session level other wise
session will fail.

Answer / karthiga

If mapping parameter and variable is used in the mapping
but nowhere defined or given, then session will fail.

we can define the Mapping parameter and variable using:
mappings>parameters and variables>declare parameters and
variables.
we will specify the value directly in default value or else
specify it in the parameter file.

Usually, we will specify in parameter file.

Answer / bsgsr

to my knowledge when the values of mapping parameter or
variable is not defined session takes null instead n hence
the session fails. they can b used in mapping or mapplet.

if wrong pls post the krect answer.

reach me on 9866188658

Answer / abhishek

we can use it in parameter files.

Answer / rao

What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?

If not declared in Parameter file, power center server will
try to fetch the value from initial value. If not then from
the default value.

Answer / karthiga

If mapping parameter and variable is used in the mapping
but nowhere defined or given, then session will fail.

we can define the Mapping parameter and variable using:
mappings>parameters and variables>declare parameters and
variables.
we will specify the value directly in default value or else
specify it in the parameter file.

Usually, we will specify in parameter file.

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

What are the designer tools for creating tranformations?

1 Answers   Informatica,

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

can we create index and drop index in exsisting table while using infomatica

4 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

What is rank index in rank transformation?

0 Answers  

what is difference between COM & DCOM?

1 Answers   Satyam,