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.

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

What is difference between a connected look up and unconnected look up?

6 Answers  

How do you take care of security using a repository manager

2 Answers  

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

Have you worked with/created Parameter file

0 Answers  

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

What is workflow monitor?

0 Answers  

How are parameters defined in informatica?

3 Answers   HP, TCS,

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,