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 a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

can we create index and drop index in exsisting table while using infomatica

4 Answers  

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

How to create the source and target database connections in server manager?

0 Answers   Informatica,

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,