Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27729 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhash
null handling in transformer in two ways
one for
1. identifing the Null values
2. Remove the Null values
1.Ans: by using Null handing function
2.Ans: By using Constrains we can Remove the Null Values Rows
In transformer
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Have you used Unstructured data?
What are the functionalities of link collector?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how do u catch bad rows from OCI stage? And what CLI stands for?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How do you run datastage job from the command line?
Name the command line functions to import and export the DS jobs?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between hashfile and sequential file?
What is the difference between server job and parallel jobs?
root tree will find which is server job and which is parallel job?
How do you import and export data into datastage?
how to write server Routine coding?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Why fact table is in normal form?
