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.

How will you combine 3 different sources with a single source?

3 Answers  

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

What is the use of source qualifier?

0 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

How can you differentiate between powercenter and power map?

0 Answers  

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,