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
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
What is CDC? How to implement CDC?
According to his methodology what all you need before you build a datawarehouse
scenario where i can use only concurrent execution of workflow.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a data modeling?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
In a table, 4 person having same salary. How to get Third person record only?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
Can we update the data in flat file using update strategy?