I have source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?
Answer Posted / rahul
use sorter trans
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What could be the possible resons of locks by user?
COM components can be used in Informatica
What is decode in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is workflow monitor?
What is the use of transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is target load order?
What is the need of an ETL tool?
What is the way to execute pl/sql script using informatica mapping?
Can we create multiple integration service on single repository?
What is data caches/ index caches?
What is the session task and command task?