Answer / santosh

1.If you have duplicate data then you can use sorter or aggregator transformation to remove duplicate.
2. If u want to delete record after 50 the row then u can use sequence genetor.
3. Write the result to a other flat file as target.
4. Use 'Post session success command' in component tab of session task to delete the old flat file and rename the target flat file to old flat file.

Please correct me if this is wrong
Thanks and regards
Santosh Kumar Sarangi

Answer / ankit kansal

Three ways to achieve the result..

1) Sorter Transformation (Distinct Oprtion)
2) Aggregator Transaformation (Group by ALL PORTS)
3) Rank Transformation (Group by ALL) and RNK=1


http://deepinopensource.blogspot.in/

Answer / subarna roy

We can write a query thru Sql transformation and delete specific records from flat file.

Answer / jvdwhinfo

Using Seq. generator we can delete the desired record from
flat file.

Please let me know if you have any suggestions.

Thanks,
James

Answer / gm

1.Why should we need to delete record from flat file?

Procedure:
We can Ignore record thru expression.
For Exp; Invalid Date, empty values some rows, etc..

Regards

Answer / davan

By using sorter t/r have the property like distinct
optation.and also aggregator t/r check group by all ports.

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

Tell me about MD5 functions in informatica

0 Answers  

What is operational data source (ODS)?

7 Answers  

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

diffrence between command task and control task

1 Answers   iNautix,

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

what is the gap analysis?

1 Answers  

which one is better either active or passive transformation in informatica

1 Answers  

Define mapplet?

0 Answers