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 / vinod upputuri

Answer Posted / vinod upputuri

Unfortunately, I didn't got the logic behind the YOUR answer.

According your logic: from aggregator stage: the output is this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985

If you join these two links then:
251
251
456
456
951
985
251,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the unique records.

in another link count<>1 means YOU get 251
456

Unfortunately this is not our desired out put, our out put is: 251
251
456
456

SO, YOUR LOGIC IS NOT ACCEPTABLE. TRY TO THINK FOR DESIRED OUTPUT !!!!

in order to get the desired out put i using the lookup-stage
in lookup i am going to lookup the out put from filter stage which is 951,985 with main data there i will specify the condition as reject:
so YOU will get the desired output!!!!!

If you can prove the above logic is wrong send me the mail!!!!

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

532

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1661

What is the importance of the exception activity in datastage?

616

What is difference between symmetric multiprocessing and massive parallel processing?

647

Explain usage analysis in datastage?

644




tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2694

Can you explain kafka connector?

768

What are the repository tables in datastage?

817

What is the difference between operational data stage (ods) and data warehouse?

665

What is a quality stage in datastage tool?

620

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076

Why we use surrogate key?

695

On which Dimension Table you implemented SCD Type in your Project

1571

What are stage variables?

630

Can you explain tagbatch restructure operator?

697