Answer Posted / 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 |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is intricate mapping?
Why update strategy and union transformations are active?
Explain about Informatica server process that how it works relates to mapping variables?
What are the main features of Oracle 8i with context to datawarehouse?
What is decode in static cache?
Which is the t/r that builts only single cache memory?
What are active and passive transformations?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a transaction control transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the new features of informatica 9.x in developer level?
How do you change a non-reusable transformation to reusable transformation?