Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
- 6 Answers
- 9099 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva
Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.
Eg: seq col1 col3
1 5 8
2 6 9
3 7 10
Seq Col2
1 1
2 2
3 3
after joining
col1 col2 col3
5 1 8
6 2 9
7 3 10
I think that resolves your problem.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is persistent lookup cache?
What is the use of code page?
How to load last n records of file into target table - informatica
How many ways a relational source definition can be updated and what are they?
Suppose we do not group by on any ports of the aggregator what will be the output?
difference between repository database and repository service?
Explain the mapping variable usage example in informatica
Does an informatica transformation support only aggregate expressions?
What is native users?
Do you find any difficulty while working with flat files as source and target?
Mention some types of transformation?
What is joiner transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is Session and Batches?
