Answer / mahi

Active transformation change the rows that pass through the mapping.

aggregator,filter,sorter,router,source qualifier,transaction control ete.. are active transformations in informatica.

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

how to insert header after each group.

1 Answers   IBM,

---

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,

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

---

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

0 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

What are the new features of informatica 9.x at the developer level?

0 Answers  

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---