Answer / lahari

There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.

Explain the different lookup methods used in informatica?

0 Answers  

---

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

---

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

---

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

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

0 Answers  

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---