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
- 8886 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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How identifying bottlenecks in various components of informatica and resolving them?
Informatica settings are available in which file?
How can you increase the performance in joiner transformation?
what is the difference between informatica6.1 and infomatica7.1
What is the function of union transformation?
What is the difference between informatica 7.0 and 8.0?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Define the various join types of joiner transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What does role playing dimension mean?
I have a flat file, want to reverse the contents of the flat file
What are the features of complex mapping?
Explain pushdown optimization $pushdownconfig parameter - informatica
