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
what is the use of surogate key in datastage
What a datastage macro?
Distinguish between informatica & datastage. Which one would you choose and why?
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
What is the different type of jobs in datastage?
Define orabulk and bcp stages?
Define ds designer?
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.
Can you highlight the main features of ibm infosphere information server?
which r the connectors used in san?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
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
Which commands are used to import and export the datastage jobs?
Differentiate between Join, Merge and Lookup stage?
What is the difference between orabulk and bcp stages?