Select Distinct Box at Source propeties level or jus override sql in Sess

What is the method of seperating unique and duplicate
records in session level?

Question Posted / jz

Answer Posted / jz

Select Distinct Box at Source propeties level or jus
override sql in Session.

Is This Answer Correct ?

17 Yes

3 No

Please Help Members By Posting Answers For Below Questions

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2673

Explain in detail scd type 2 through mapping.

985

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1023

What is a difference between complete, stop and abort?

1027

Explain how to import oracle sequence into informatica?

946

What is the fact table?

990

Explain the code page compatibility?

1021

Explain lookup transformation source types in informatica

1037

Mention some types of transformation?

988

Can you generate sequence numbers without using the sequence generator transformation?

1040

what is mean by complex business rule ?

2106

How to handle decimal places while importing a flatfile into informatica?

1126

design of staging area?

1957

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1192

What is meant by a domain?

1077