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

How many transformations can be used in mapplets.

1873

How to use procedural logic inside infromatica?

1138

Clarify the utilization of aggregator cache record?

945

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1733

What are the performance considerations when working with aggregator transformation?

1097

How will the document be delivered to me?

1020

Can we get 1st record through Informatica(without sequence number).

1410

Define mapping and session?

973

What is a difference between complete, stop and abort?

1033

What are the different lookup cache(s)?

1036

Explain the use of aggregator cache file?

1191

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5688

What is difference between a gateway node and worker node?

1069

Write the program through which the records can be updated?

938

What is meant by query override?

1008