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
- 24602 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 is data partitioning?
Explain the situation where you have applied SCD in your project?
How can one find bugs in job sequence?
What are the types of containers?
What is usage analysis in datastage?
What are some different alternative commands associated with "dsjob"?
State the difference between an operational datastage and a data warehouse?
What are the important features of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the various kinds of the hash file?
What is the difference between orabulk and bcp stages?
Enlist various types of routines in datastage.
On which interface you will be working as a developer?
Difference between server jobs & parallel jobs?
