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

What is the Process to creating lookup transformation in informatica

1 Answers   Informatica,


list out all the transformations which use cache?

1 Answers   Informatica,


what is unit testing?tell me proceedure

1 Answers   L&T, UST,


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


Explain the different dimensions.

1 Answers  


i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


Explain factlessfact table with scenario

1 Answers   HCL,


Major difference between SQL override and Lookup Sql override

1 Answers  


What is a repository? And how to add it in an informatica client?

1 Answers   Informatica,


what is the size of u r project? and what is the size of source file?

1 Answers   HP,


Categories