What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 24 Yes | 3 No |
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.
Is This Answer Correct ? | 8 Yes | 0 No |
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
Is This Answer Correct ? | 10 Yes | 2 No |
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.
Is This Answer Correct ? | 9 Yes | 2 No |
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.
Is This Answer Correct ? | 3 Yes | 3 No |
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.
Is This Answer Correct ? | 2 Yes | 2 No |
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
Is This Answer Correct ? | 5 Yes | 6 No |
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.
Is This Answer Correct ? | 0 Yes | 3 No |
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.
Is This Answer Correct ? | 0 Yes | 4 No |
Briefly describe lookup transformation?
WAT IS TEXT LOAD?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
How to create or import flat file definition in to the warehouse designer?
How to extract the informatica rejected data?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
what is surrogate id ?
What are the active and passive transforamtions?
what are the challenge face in u r project?explain me
what r the transformations that r not involved in mapplet?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
how to we create datamart?