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

Can you generate reports in Informatcia?

1 Answers  


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


What is mapplet in informatica?

0 Answers  


I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,






i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


How to join three sources using joiner? Explain though mapping flow.

0 Answers  


What are roles and groups and benefits of using them?

0 Answers  


what is flat file override?

1 Answers   Cap Gemini, HP,


Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  


How to do unit testing in informatica?

0 Answers  


Categories