What is the Difference between SetVariable and setmaxvariable
in informatica?
Answer / abhinav
Set variable:Sets the current value of a mapping variable to
a value you specify.
Exa:SETVARIABLE ($$Time, SYSDATE)
SetMaxVariable:Sets the current value of a mapping variable
to the higher of two values.
Exa:SETMAXVARIABLE ($$MAXITEMS, ITEMS)
| Is This Answer Correct ? | 9 Yes | 3 No |
what are testing in a mapping level please give brif eplanation
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
tell me about your project functionality
What is meta data and system catalog?
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
Which is costliest transformation? costly means occupying more memory?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
How would you copy the content of one repository to another repository?
Can u generate reports in Informatica?
What are the reusable transformations?
What are the challenges you have faced in your project?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?