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.

differences between service based and product based?

2060

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2902

---

How to join three sources using joiner?

1197

---

Define pmcmd command?

1106

---

What is domain and gateway node?

1208

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1213

---

Explain sessions?

1140

---

What if the source is a flat-file?

1170

---

Write the different tools in the workflow manager?

1119

---

What is sorter transformation?

1111

---

What is blocking transformation?

1189

---

What are the differences between source qualifier and joiner transformation?

1137

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2202

---

I have a flat file, want to reverse the contents of the flat file

1172

---

What are active transformations.

1704

---