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 |
What is the different lookup cache(s)?
What are the different components of powercenter?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to update records in Target, without using Update Strategy?
What is substr in informatica?
What is confirmed dimension and fact?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
In a sequential batch can u run the session if previous session fails?
What do you mean by enterprise data warehousing?
What are session parameters ? How do you set them?
What are the tasks that can be performed using sq?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.