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

Answer Posted / kittu

Before using mapping parameters or variables first we hav to declare them in mapping level.After that we can create parameter file with .txt or .prm extension . Mapping parameters are used when the requirement need the values that cannot change with in session where as mapping variables can change the value with in session the best example for mapping variable are we can use them in concept of Increamental Loading and also to generate sequence numbers with out using sequence Generator Transfomation.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1628


Which files are created during the session rums by informatics server?

714


permutations of mapplet

2048


How can we handle two sessions in informatica?

623


What is expression transformation?

641






is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

635


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

786


What is a difference between complete, stop and abort?

646


Explain transaction control transformation in informatica

769


What is dynamic cache?

618


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1743


Enterprise data warehouse your projects phase by phase explain?

1476


What is meant by a domain?

638


Explain sql transformation in script mode examples in informatica

612


What are the static cache and dynamic cache in informatica?

728