Interested to Buy Any Domain ? << Click Here >> for more details...
in datastage interview qustion
source target
------- -------
12345 1
2
3
4
5
- 3 Answers
- 6795 Views
- IBM, YCS, I also Faced
- E-Mail Answers
Answer Posted / lajpat kurdiya
SELECT SUBSTR(12345,LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH(12345);
SELECT SUBSTR('12345',LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH('12345');
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of jobs we have in datastage?
What is a folder? Difference types of stages?
If you want to use the same piece of code in different jobs, how will you achieve it?
how to export or import the jobs in .ISX file
What are datastage sequences?
What is the difference between datastage and datastage tx?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Could anyone give brief explanation bout datastage admin
Why do we use exception activity in Datastage?
What are the job parameters?
Notification Activity
What is the difference between operational data stage (ods) and data warehouse?
How many Key we can define in remove duplicate stage?
Triggers,VIEW,Procedures
In Datastage, how you can fix the truncated data error?
