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
Answers were Sorted based on User's Feedback
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
how to get max value record into one target and remaining records into another target?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What is source qualifier transformation in informatica?
What are connected or unconnected transformations?
What is the sql query overwrite in source qualifier in informatica
Describe two levels in which update strategy transformation sets?
star and snowflake schema?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
can you use flat file for lookup table?why?
What could be the possible resons of locks by user?
Explain grouped cross tab?