Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27936 Views
- I also Faced
- E-Mail Answers
Answer Posted / sailaja
Hi,
For Null handling in transformer you can use the below function dependind on ur requirement
1. Nulltoempty
2. Nulltozero
3.Nulltovalue
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different kinds of views available in a datastage director?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are sequencers?
how can we create rank using datastage?what is the meaning of rank?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do you schedule or monitoring the job?
What is difference between server jobs & parallel jobs?
how many rows sorted in sort stage by default in server jobs
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the types of containers?
What is use Array size in datastage
What is a datastage job?
What is the purpose of pivot stage and types of containers in datastage
If you want to use a same piece of code in different jobs, how will you achieve this?
