How to get two targets T1 containing distinct values and T2 containing duplicate values from one source S1.

  • Interview Candidate
  • 3
  • 2047

Showing Answers 1 - 3 of 3 Answers

mallika

  • May 9th, 2006
 

Use filter transformation for loading the target with no duplicates. and for the other transformation load it directly from source.

  Was this answer useful?  Yes

gop

  • Jun 14th, 2006
 

hi,

how you seperate distinct value using filter, where you write no dictinct value. please make it more clear.

  Was this answer useful?  Yes

Abhik

  • Nov 1st, 2006
 

if the source is relational u can use DISTINCT option in SQ and if it flat file u can use sorter for this

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions