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

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

Question Posted / guest

1 Answers
7294 Views
IBM, I also Faced
E-Mail Answers

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

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers TCS,

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers Accenture,

What are the disadvantages of Sequence Generator T/R?

3 Answers Zensar,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers IBM,

What happens when a session fails and you click on recover?

0 Answers

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers HP,

What is diff between connected and unconnected lookup?

5 Answers BirlaSoft, Blue Star Infotech,

why we use stored procedure transformation?

4 Answers IBM,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers TCS,

diffrence between command task and control task

1 Answers iNautix,

For more Informatica Interview Questions Click Here