how can u handle null values in transformer stage.

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


Please Help Members By Posting Answers For Below Questions

Give an idea of system variables.

575


how many rows sorted in sort stage by default in server jobs

3545


What are the types of hashed files in data stage

634


What are the enhancements made in datastage 7.5 compare with 7.0?

702


What is difference between server jobs & parallel jobs?

615






in oracle target stage when we use load option and when we use upsert option?

1738


What is aggtorec restructure operator?

709


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2713


Difference between sequential file and data set?

631


Differentiate between odbc and drs stage?

583


What are the main differences you have observed between 7.x and 8.x version of datastage?

612


What all the types of jobs you developed?

659


What is the difference between Datastage 7.5 and 7.0?

663


What are the processing stages?

633


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2415