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
- 5 Answers
- 11611 Views
- Accenture, I also Faced
- E-Mail Answers
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
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Is there any target staging area in informatica not staging area
How to delete duplicate row using informatica?
What do you understand by term role-playing dimension?
lookup transformation with screenshots
What do mean by local and global repository?
What is the use of an aggregator cache file?
What are the data movement modes in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is a shortcut and copy in Informatica and how two are different with each other?
How is union transformation utilized?
Enlist the advantages of informatica.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain constraint based loading in informatica
