When do you use mapping parameters? (In which transformations)
Answer / saikrishna
mapping parameters are rarely used.when we have situation like,we want to give appraisal to employees after complition his first year so we just assign the mapping parameter in mapping designer. now we just specify the value of extra amount the it will works. it tooks all transformations based on the requirements.
| Is This Answer Correct ? | 2 Yes | 0 No |
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Which transformation is needed while using the Cobol sources as source definitions?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Without using Lookup & Sequence Generator, How to generate Sequence?
What is the difference between Power Centre and Power Mart?
What is meant by pre and post session shell command?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Explain how to import oracle sequence into informatica?
server hot-ws270 is connect to Repository B. What does it mean?
Why update strategy and union transformations are active? Explain with examples.
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.