Answer / divi

I think we can change it in session properties of mapping
tab.if select flatfile on top of that we see set file
properties.

Answer / bsgsr

hi, divi,
ur access to the subject is cool.
i go with your answer.
thanks.

Answer / abhinav

@Divi: I did not understand your answer. Can somebody
please explain what exactly did Divi suggest doing?

I can only think of using a pre-session shell script to
replace all commas with any other delimiter.

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,

---

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

0 Answers  

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

How mapping parameter and variable works

1 Answers  

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---