Interested to Buy Any Domain ? << Click Here >> for more details...
What are mapping parametres and variables in informatica?
- 6 Answers
- 35278 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / b.gopala rao
Mapping Parameters: Mapping parameter is a constant value
which points to any datatype in the entire mapping. its
value will not be changed as earlier said.
Mapping variable: Mapping variable is same thing like
mapping parameter except its value will be changed in the
mapping.
For define the value you can give the intial value or you
can create mapping parameter file. But in the file you
should specify the folder name. session name .
Ex:
[foldername.sessionname]
$$parameter1=100;
Otherwise informatica server can not recognize
the session.
| Is This Answer Correct ? | 36 Yes | 2 No |
Answer / bsgsr
mapping parameters and variables make the mappings reusable
and saves time. ex: u have created a mapping to load the
data of only deptno 10 into the target. next time if you
want to load the data of deptno 20 u have to create the
mapping again which is fom the scratch again. if you create
a parameter and define the value in the parameter file you
can simply change the value of the parameter and can use
the mapping again.
mapping parameter represents a constant value that doesnt
change during the session run where as mapping variable
represents a value which changes during the session run
and saves the max value to the repository which is used
next time when you run the session.
| Is This Answer Correct ? | 36 Yes | 2 No |
Answer / gopi
mapping parameter: it is a static.. the value cannot be
changed thorughout the session..
variable: it is dynamic..the value can be stored at the end
of session and the value cane be used next time run the
session
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandramohan reddy
Mapping parameter is a constant value that cannot be changed
during the mapping run.it is saved with an extension .PRM
Mapping variable is a value which can be changed during the
mapping run.
| Is This Answer Correct ? | 6 Yes | 8 No |
Answer / sid
you can change the value of a parameter in the mapping.The
new value will be stored in the repository.In case in the
next session run you for some reason fail to define the
parameter in the parameter file informatica will pick up
the last value form the reposiroty
| Is This Answer Correct ? | 2 Yes | 9 No |
Answer / raja
mapping parametres is constant value it should defines in
separately using mapping parametres create function provided
informatica server,
it use to create name,type,datatype,precision,scale.
mapping variable should varied when the each tome session
runs,it also use to create
name,type,precision,scale,aggreation.
it mainlyuse full for incremental load processing
| Is This Answer Correct ? | 5 Yes | 15 No |
What are the types of lookup transformation?
what is session override?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Differentiate between a database and data warehouse?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
what is target load plan
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is mapping parameter?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Teradata 
