Interested to Buy Any Domain ? << Click Here >> for more details...
what are the perameter and variable?
- 3 Answers
- 8159 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
parameter and variables used in the mappings indeed make
them reusable incase a single element of the mapping needs
to be changed. This way it saves the dev time to build the
whole mapping again.
parameter once defined and value is assigned will not
change its value during the session run.
Unlike parameter, a variable changes its value through out
the session run.
this is my prception of the question.
kum lets share knowledge and help one another find a break
with the industry. U feel so reach me on bsgsr12@gmail.com
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / jang
Mostly Parameters are used, where u want mapping to do
Change Data Capture, here we use the Source port value
compare against Parameter value in SQL override of SQ TRN.
Once this WFl completes , immd...then update the parameter
value using other WFL.
The syntax to declare a Parameter is
[Foldername.WF:workflowname.ST:sessiontaskname]$$parametername
='date value' or 'value'.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kammari.krishnaiah
hi this is krishna
my answer is variable is which varies the value means changes.
perameter is a stores the value it cant change the value
| Is This Answer Correct ? | 0 Yes | 1 No |
what is the architecture of any Data warehousing project?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
what is the hint? how to use it to reduce the query processing in program?
Describe data concatenation?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
How to create or import flat file definition in to the warehouse designer?
what is data driven in update strategy transformation?
How to recover sessions in concurrent batches?
What is meant by active and passive transformation?
what is the size of u r source(like file or table)?
Teradata 
