Explain about the concept of mapping parameters and
variables ?
Answers were Sorted based on User's Feedback
Answer / neena
Mapping parameters represents a constant value that we cant
change during the seesion run.
Mapping variables represents a value that we can change
during the seesion run.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / manju
Mapping parameters s a constant value and mapping variables
will change in the mapping.It is mainly usefull for
incremental load processing
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rekha
MAPPING PARAMETERS :
MAPPING PARAMETERS REPRESENT A CONSTANT VALUE AND DOES NOT
CHANGE DURING THE SESSION
MAPPING REUSABILITY CAN BE ACHEIVED
MAPPING VARIABLE REPRESENTS A VALUE THAT CHANGE THE VALUE
DURING THE EXECUTION FROM INITIAL VALUE TO THE FINAL VALUE
MAPPING VARIABLES USE IN INCREMENTAL LOAD PROCESS
Is This Answer Correct ? | 3 Yes | 0 No |
whether Sequence generater T/r uses Caches? then what type of Cache it is
Do joiner transformation use cache? If so describe?
what are the row and column separations in Flat Files
Can we call a stored procedure from a unix script which is run using command task
how to return multiple columes through through un-connect lookup?
what are 3 tech challenges/ common issues you face?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
what is the difference between static and dynamic
what is the use of Java Transformation in Informatica 8.x?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is difference macros and prompts?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort