How to reverse the string using SQL?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

What are the repository tables in datastage?

0 Answers  


Describe the main features of datastage?

0 Answers  


Explain ibm infosphere information server and highlight its main features?

0 Answers  


Name the different types of Lookups in Datastage?

0 Answers  


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


What is the sortmerge collector?

0 Answers  


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,


Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  


Categories