Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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

2121


Different sorts of metadata that stores in the storage facility?

1008


Write the different tools in the workflow manager?

1060


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?

1078


How many ways are there to create ports?

1327


How can we update a record in the target table without using update strategy?

1139


Reusable transformation and shortcut differences

1838


hi real timers . iam waiting for ur reply regarding ETL TESTING

2267


Enterprise data warehouse your projects phase by phase explain?

1917


Write the unconnected lookup syntax?

1082


What are the tasks that source qualifier perform?

1097


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?

2177


update strategy transformation in informatica

1064


can u any challenge your project?

2029


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1077