Answer / srinivas kondeti

SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM

Answer / chandrasekar

Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.

Answer / 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.

Answer / rahul

In Informatica use aggrigator on group by Col1 Col2 Col3.

Explain grouped cross tab?

1 Answers   Accenture,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

how did u understand business requirement?

2 Answers   TCS,

---

what is materialized view?

2 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

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?

0 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

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

0 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---