Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Friends
I have a sql question, We have the source data as below.
101 address1, address2, address3
and the output shoulb like below
101 address1
101 address2
101 address3
Required a SQL query for this output.
Please let me know if you have any sql query for this.
Thanks in advance.
Hari M
- 6 Answers
- 13278 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Hi Hari,
IF the source data is present in a file, then it can
be handled in the supporting OS say unix or mainframe,
whichever is being used. But the input data is present in a
single column, then i think UDF has to be used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain teradata architecture in detail with a diagram.
What can be achieved by using the teradata rdbms?
What is the syntax for case when statement?
What is meant by a Parsing Engine?
What are the various etl tools in the market?
What is the multi-insert?
How many types of joins are there in teradata?
What are the different design perspectives used in teradata?
Is multi insert ansi standard?
Explain the term 'columns' related to relational database management system?
What is the use of virtual processor connectivity in teradata?
Differentiate primary key and partition key?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How to find duplicates in a table?
How to Extract data from multiple legacy systems?
