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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / reddy
Hi lakshmi in filter t/r in operator not supported,
GM Answer is good
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / a.venkata lakshmi
select id,name from tablename where id in(101,102,103)
Is This Answer Correct ? | 0 Yes | 11 No |
My source table having some records ,i want load 1st record and last record into one target?
without using rank transformation how can we rank items by using some other transformations
What is difference between partioning of relatonal target and partitioning of file targets?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
How to load the data from people soft hrm to people soft erm using informatica?
Can any one explain or sujjest some sites for scd mappings.Thank you
What are the types of schemas we have in data warehouse and what are the difference between them?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to load a relational source into file taget?
Explain load alternative records / rows into multiple targets - informatica