what transformations are used for Variable port?
Answers were Sorted based on User's Feedback
Answer / murali krishna
We can use Variable port in the following transformations.
1. Expression Transformation
2. Aggregated transformation
3. Rank Transformation
| Is This Answer Correct ? | 49 Yes | 3 No |
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What is an active transformation?
what are the different types of transformation available in informatica and what are the mostly used ?
how to run the batch using pmcmd command
what is the purpose of surrogate key and diff between primary key&surrogate key
What is lookup change?
how can we run workflow with pmcmd?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
What is update strategy transform?
What are the phases in SDLC?
What is the maplet?