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
- 8800 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
Differentiate between router and filter transformation?
How can you validate all mappings in the repository simultaneously?
Why filter transformation is an active one?
How to create a non-reusable instance of reusable transformations?
Different qualification between a related rotate toward the sky and isolates look upward?
What is complex mapping?
How to create the source and target database connections in server manager?
What are the mapping parameters and mapping variables?
What do you understand by a term domain?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the limitations of joiner transformation?
Where are the source flat files kept before running the session?
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?
Could you explain what is enterprise data warehouse?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
