Interested to Buy Any Domain ? << Click Here >> for more details...
Where do you create/define mapping parameter and mapping variable?
- 1 Answers
- 3220 Views
- I also Faced
- E-Mail Answers
Answer / rajesh kumar
We can create mapping parameters and variables in mapping designer/mapplet designer.
We can define the value within the transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
What are the designer tools for creating tranformations?
what are cost based and rule based approaches and what is the difference?
How to load data in informatica ?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
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
What are the components of the workflow manager?
How to identify this row for insert and this row for update in dynamic lookup cache
Differnce between filter and router?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
what is the look up transformation?
Teradata 
