1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring

Question Posted / pnvnreddy

Answer Posted / pnvnreddy

Hi Shiva ur right

---------Agg -tar1
----------/ \ -/
seq---copy--join---filter---tar2

in Agg
Agg type=count

in filter
count=1-----tar1
count>1-----tar2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you import and export data into datastage?

691

Define oconv () and iconv () functions in datastage?

871

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1773

Explain the situation where you have applied SCD in your project?

1554

What is datastage engine?

726




How will you move hashed file from one location to another location?

1649

Can you filter data in hashed file?

3337

Explain usage analysis in datastage?

644

What is difference between join, merge and lookup stage?

632

What is the purpose of pivot stage?

598

What is the use of datastage director?

580

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1891

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

955

what is the difference between == and eq in UNIX shell scripting?

967

how to write server Routine coding?

1654