write sql query to filter the null value data following
table?
name age
john 30
smith null
null 34
sharp 24
i want the output following are
name age
john 30
sharp 24
- 2 Answers
- 5683 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / subbu
select * from table name where name is not null and
age is not null
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
How big was your fact table
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain sql transformation in script mode examples in informatica
Explain the different dimensions.
How can we handle two sessions in informatica?
What are active and passive transformations?
How is union transformation utilized?
Define pmcmd command?
What are the new features of informatica 9.x in developer level?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the components of the workflow manager?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is parallel processing in informatica?
How does the aggregator transformation handle null values?
How to generate sequence numbers?
