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
- 24215 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
project Steps,hits, Project level HArd things,Solved methods?
Differentiate between odbc and drs stage?
How the ipc stage work?
What is a quality stage in datastage tool?
What are the types of hashed files in data stage
What are stage variables, derivations and constants?
What is the differentiate between data file and descriptor file?
client know skid info?
Difference between sequential file and data set?
What is the purpose of interprocessor stage in server jobs?
What are constraints and derivations?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Can you filter data in hashed file?
What are the partitioning techniques available in link partitioner?
Give an idea of system variables.
