Answer Posted / fiero

Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.

Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.

Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.

Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.

Write the unconnected lookup syntax and how to return more than one column.

1121

---

What is data movement mode in Informatica and difference between them?

1151

---

How do you use reject loader.

2616

---

What is expression transformation?

1113

---

Separate from a database, an information bazaar, and an information stockroom?

1095

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2204

---

What is rank transformation in informatica

1186

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2017

---

Define Pmrep command?

1077

---

How to create or import flat file definition in to the warehouse designer?

1078

---

What are active transformations.

1660

---

Differentiate between a repository server and a powerhouse?

1130

---

wf dont have integration severances how you can run?

1947

---

Explain the tuning lookup transformation - informatica

1001

---

Enlist some properties of sessions.

1095

---