what is procedure to use mapping variable in source
qualifier transformation? with example



what is procedure to use mapping variable in source qualifier transformation? with example..

Answer / vemuri vijay

steps
go to source qulifier transformation wtih along with source
and target after that go to the
properties,select user defined join sql editor will open
after that there is two optins on left hand side select
variablel in that there is mapping variables available

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,


Explain your project of banking domian.

0 Answers   Cap Gemini,


What are differences between Informatica 7.1 and 6.1

3 Answers  


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  






What are the basic needs to join two sources in a source qualifier?

3 Answers  


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


What is a sequence generator transformation?

0 Answers  


Whats the difference between $, $$, $$$

9 Answers  


How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,


How to do unit testing in informatica? How to load data in informatica ?

0 Answers  


Categories