how can u handle null values in transformer stage.
Answer Posted / rajeshchunduri
in transformer we have null handling functions in that by
using null to zero we can handle null.
chunduri
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
What are routines in datastage?
Explain connectivity between datastage with datasources?
What is the difference between an operational datastage and a data warehouse?
How can you write parallel routines in datastage PX?
How one source columns or rows to be loaded in to two different tables?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the stages in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the some differences between 7.x and 8.x version of datastage?
How can we improve performance of data stage jobs?
What is a merge in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
Which warehouse using in your datawarehouse