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
- 13229 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
What is meant by a Virtual Disk?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the purpose of joins in teradata and what are the available join types?
How many tables can you join in v2r5?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain parsing engine in teradata?
What is primary index and secondary index?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain how spool space is used.
In Teradata, how do we Generate Sequence?
What is the maximum number of dml can be coded in a multiload script?
Explain the term 'columns' related to relational database management system?
What type of indexing mechanism do we need to use for a typical data warehouse?
Steps to create a data model?
Explain the term 'tables' related to relational database management system?
