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
- 13525 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 the meaning of Amp?
Describe primary index in teradata. And what are the available primary index types?
Explain the most common data types used in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is teradata? Also, list out some of the primary characteristics of teradata.
Describe primary index in teradata?
Explain and compare pros and cons of start schemas?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the steps to create a data model?
Explain the teradata primary index mechanics in detail with a diagram.
What is the multi-insert?
How do you do backup and recovery in teradata?
What are aggregate tables? How do you design them using teradata?
What is meant by a Clique?
What are default access rights in teradata?
