Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / prasad_bestha
source table
col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc
target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
can u give example for factless fact table
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is aggregate cache in aggregator transformation?
What is native users?
How to update or delete the rows in a target, which do not have key fields?
Which version configuration tool used in ur project?
What are the different options available for update strategy?
tell me 5 session failure in real time how can you solve that in your project?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
design of staging area?
What are the types of schemas we have in data warehouse and what are the difference between them?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is degenerated dimension?
What is workflow monitor?
