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 table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


Can we create two repositories on same database instance in oracle?

0 Answers  


How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  


2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,






If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


How many transformations can be used in mapplets.

0 Answers  


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


can we see default group,when we use router?if yes how?

2 Answers   L&T,


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  


Categories