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
- 24539 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
how can we create rank using datastage?what is the meaning of rank?
EXPLAIN SCD
How many areas for files does datastage have?
Name the different types of Lookups in Datastage?
What is ibm datastage flow designer?
Can you highlight the main features of ibm infosphere information server?
If you want to use a same piece of code in different jobs, how will you achieve this?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Differentiate between operational datastage (ods) and data warehouse?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to run a sequential file stage in parallel if the stage is used on the TARGET side
what is flow of project?
What are the difference types of stages?
Where do the datastage jobs get stored?
Triggers,VIEW,Procedures
