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.

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

How to recover the standalone session?

2 Answers  

How do you load only null records into target? Explain through mapping flow.

0 Answers  

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

why we r using presql&postsql in source qualifier?

1 Answers   HP,

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

What are the parts of Informatica Server?

1 Answers   Cognizant,

Explain factlessfact table with scenario

1 Answers   HCL,