My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000).
In the Target I want the following EmpID, Salary,
Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103,
3000, 6000). Please guide on how to build the mapping.
Answer Posted / rambhupal
by using variable port also we can solve this.create one variable port and output port,assign that v_count=v_count+salary,for out port o_count=v_count
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can anyone explain me about retail domain project in informatica?
What is meant by lookup transformation?
What is a surrogate key?
How do you manage the Parameter files while migrating your data from one environment to another environment?
write a query to retrieve the latest records from the table sorted by version(scd)
lookup transformation with screenshots
Explain scd type 3 through mapping.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a joiner transformation?
What is source qualifier transformation in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a pre-defined event and user-defined event?
What is the scenario which compels informatica server to reject files?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Where can we find the throughput option in informatica?