Answer Posted / masudul

Just pass the rows through an expression transformation.
then add a new port and write down the expression code-

substr(column_name, 1, (instr(column_name,'@')-1)).

See the output.

What is a grid in Informatica?

998

---

What is a difference between complete, stop and abort?

1029

---

Differentiate between a database and data warehouse?

1087

---

What are the settings that you use to configure the joiner transformation?

996

---

What is aggregate cache in aggregator transformation?

1058

---

How to generate sequence numbers using expression transformation?

1025

---

What's the layout of parameter file (what does a parameter file contain?)?

2331

---

What are the guidelines to be followed while using union transformation?

1064

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2120

---

What can we do to improve the performance of informatica aggregator transformation?

1041

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1071

---

Plz can any one say me how to get the informatica certification materials and dumps

1998

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6038

---

What differs when we choose the sorted input for aggregator transformation?

966

---

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

---