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
- 7117 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
use sort for col2
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
What are the types of schemas we have in data warehouse and what are the difference between them?
scenario where i can use only concurrent execution of workflow.
What is aggregator transformation in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Difference between Data and Index Caches?
How to delete duplicate row using informatica?
Briefly define reusable transformation?
Explain incremental aggregation in informatica
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 are the mapping parameters and mapping variables?
What is a mapplet/worklet in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is native users?
What are the features of complex mapping?
