Answer / sunil

To eliminate duplicates from flat file use sorter in that
select distict option...it will work

Answer / ram

one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...

Answer / paulo coelho

In an Unix environment, do:

page YourFile | sort | uniq -c

Answer / muddam

Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.

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

0 Answers   Informatica,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

what is hash table in informatica?

1 Answers   Zensar,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

Write the program through which the records can be updated?

0 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---