in datastage interview qustion
source target
------- -------
12345 1
2
3
4
5
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 enhancements made in datastage 7.5 compare with 7.0?
What is orabulk stage?
What are the stages in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What are the various kinds of containers available in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the primary usages of datastage tool?
what is the use of skid in reporting?
How many Key we can define in remove duplicate stage?
How complex jobs are implemented in datstage to improve performance?
Differentiate between operational datastage (ods) and data warehouse?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Name the different types of Lookups in Datastage?
How can you write parallel routines in datastage PX?
What are stage variables and constants?