In real time scenario where can we use mapping parameters
and variables?

Answer Posted / bsgsr

mapping variable unlike mapping parameter changs its value
during session execution. it is used in incremental loading.

parameters are used in many scenarios like loading the data
of employees who joined ina particular year, for
timestamping, loading the data related to a particular
product id. alike.

if i am wrong let me know.
bsgsr12@gmail.com

Is This Answer Correct ?    21 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size of your data warehousing?

1842


Have you worked with/created Parameter file

1387


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1723


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2044


How many transformations can be used in mapplets.

1643






What are the transformations that are not supported in mapplet?

770


Explain why we use partitioning the session in informatica?

778


How to improve the performance of a session using sorter transformation?

889


How to do unit testing in informatica?

916


How to extract the informatica rejected data?

946


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

750


What do think which one is the better joiner or look up?

950


In informatics server which files are created during the session rums?

833


What is powercenter on grid?

913


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1434