write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma
i want the output
id name
101 dinesh
102 suresh
103 prakesh
Answer Posted / gm
Rama you are correct.
In Additional For Informatica
S-SQ-FLT-TGT
FLT:
Condition
IIF(NOT ISNULL(ID),True,False)
Regards
GM
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Different sorts of metadata that stores in the storage facility?
Write the different tools in the workflow manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How many ways are there to create ports?
How can we update a record in the target table without using update strategy?
Reusable transformation and shortcut differences
hi real timers . iam waiting for ur reply regarding ETL TESTING
Enterprise data warehouse your projects phase by phase explain?
Write the unconnected lookup syntax?
What are the tasks that source qualifier perform?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
update strategy transformation in informatica
can u any challenge your project?
Under what conditions selecting sorted input in aggregator will still not boost session performance?