Answer Posted / sasibushan

This will work

SELECT Max(CASE WHEN col1 IS NOT NULL THEN col1 END) AS "col1",
Max(CASE WHEN col2 IS NOT NULL THEN col2 END) AS "col2",
Max(CASE WHEN col3 IS NOT NULL THEN col3 END) AS "col3"
FROM Table_name

Convert this logic to Informatica...

Sasi.

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2029

---

differences between service based and product based?

2010

---

How can we improve session performance in aggregator transformation?

1110

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2718

---

In informatica workflow manager, how many repositories can be created?

1350

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1939

---

What is workflow manager?

1038

---

How to improve the performance of a session using sorter transformation?

1142

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1898

---

What are the guidelines to be followed while using union transformation?

1134

---

 Informatica Checkpoints

3325

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1071

---

Where do we use mapping variables in informatica?

1061

---

Difference between Target-based loading and constraint-based loading?

994

---

What are the databases that informatica can connect to windows?

1044

---