Interested to Buy Any Domain ? << Click Here >> for more details...
I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
- 7 Answers
- 24342 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / krishna
As per my knowledge
initially soure is in sequential stage anc take aggrigator
stage and select the grouping option and select which column
you want to group then go to option command and select
column for calculation and select the which column you want
to do the operation .in column for calculation w have seen
many options and select missing count column name and give
the column name for output.and add transformer stage with in
the transformer stage add constraints .and give the two outputs
if column name=1 then 1 else 0
if column name>=2 then 1 else 0
it will work
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What are the stages in datastage?
Name the different types of Lookups in Datastage?
Can you implement SCD2 using join, transformer and funnel stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Define Job control?
Where do the datastage jobs get stored?
Describe stream connector?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the difference between orabulk and bcp stages?
Differentiate between Join, Merge and Lookup stage?
Describe routines in datastage? Enlist various types of routines.
Define project in datastage?
Where the datastage stored his repository?
