Answer Posted / sandya

hi
if it is excel sheet, save as in CSV format, while importing
csv file in informatica designer, check 'Singlequotes' under
Text qualifier. it separates as both city and state in to
two columns which is in one column. after that double quotes
appear on the top of city and column. we can remove using
trim.previously i have tried this and got result.

What is a sequence generator transformation?

950

---

How can one identify whether mapping is correct or not without connecting session?

1367

---

can we override a native sql query within informatica? How do we do it?

1048

---

What is the status code in stored procedure transformation?

1118

---

What is data transformation manager process?

1077

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2388

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2063

---

Explain lookup transformation source types in informatica

1038

---

What is a surrogate key?

1014

---

without table how to come first record only in oracle?

2200

---

Can we create multiple integration service on single repository?

1130

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905

---

Design time, run time. If you don't create parameter what will happen

1792

---

What are the main features of Oracle 8i with context to datawarehouse?

2051

---