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
What do you mean by blocking transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
lookup transformation with screenshots
Design time, run time. If you don't create parameter what will happen
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are some examples of informatica etl programs?
Why is sorter an active transformation?
What do you understand by term role-playing dimension?
Which transformation should we use to normalise the COBOL and relational sources?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is decode in static cache?
How can we update a record in the target table without using update strategy?
What is informatica? Why do we need it?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to load a Dimension ? and how to load a fact table?