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

what is the use of surogate key in datastage

1823


What a datastage macro?

638


Distinguish between informatica & datastage. Which one would you choose and why?

587


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

1471


What is the different type of jobs in datastage?

576






Define orabulk and bcp stages?

690


Define ds designer?

768


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.

2430


Can you highlight the main features of ibm infosphere information server?

639


which r the connectors used in san?

1792


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2746


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

543


Which commands are used to import and export the datastage jobs?

985


Differentiate between Join, Merge and Lookup stage?

647


What is the difference between orabulk and bcp stages?

578