u can use unix command in pre session as sort -u file1 >newfile

How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?

Question Posted / prasad

Answer Posted / prasad

u can use unix command in pre session as sort -u file1
>newfile

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain what is informatica metadata and where is it stored?

998

Can we create a Integration service without a Repository service and vice versa?

1180

What is Session and Batches?

1048

How would you copy the content of one repository to another repository?

968

what is the -ve test case in your project.

2344

what is informatica metadata?

982

Explain the etl program with few examples.

982

Tell me about MD5 functions in informatica

884

what is index?how it can work in informatica

1988

What is difference between a gateway node and worker node?

1081

Whats the difference between informatica powercenter server, repositoryserver and repository?

1127

whats the logic to load the lower level of granularity of data to fact table.

2217

What is workflow? What are the components of the workflow manager?

1078

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

924

How can you define user defied event?

986