How to convert alpha Numeric values to alpha using functions?
Answer / niraj pathak
Using convert function
Sv1=convert (0123456789,col1,"")
Is This Answer Correct ? | 0 Yes | 0 No |
What is meta stage?
Can we use Round Robin for aggregator?is there any benefit underlying?
how do u reduce warnings
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
what is the main difference between sorragate key n primary key in one word
where the log files or tables can store in DS?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is a quality stage?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
Which warehouse using in your datawarehouse
Is it possible to query a hash file?