Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Answer / isha
The parameters and variables declared in the mapplet are not reusable in a
mapping. They are specific to a mapplet.
If you are using the mapplet in a mapping in that case, you have to declare
the same set of parameters or variables in your mapping aswell.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is joiner change?
How to generate sequence numbers without using the sequence generator transformation?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
What are the new features of informatica 9.x at the developer level?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
What is the procedure to load the fact table.Give in detail?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
How can informatica be used for an organization?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
While importing the relational source defintion from database,what are the meta data of source U import?