what is sql override?what is the use of it?

4 Answers   Sonata,

---

What does command task mean?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

Which kind of index is preferred in DWH?

3 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---