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.

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

What is joiner cache?

2 Answers   TCS,

Why we require dwh in particular projects?

1 Answers   Amdocs,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

What does command task mean?

0 Answers  

Is stop and abort are same in informatica?

0 Answers