Interested to Buy Any Domain ? << Click Here >> for more details...
my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
- 4 Answers
- 9554 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandra
take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1
SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2
| Is This Answer Correct ? | 11 Yes | 8 No |
Answer / santosh kumar sarangi
1.first sort the data with sorter t/r as ID key column and
create below port in exp transformation
var2= var1
id
var1=id
rec_count=iff(var1=var2,rec_count+1,1)
2.Give all the port to router t/r and give the filer
condition as below
rec_count=1 then to first target
default to 2nd target
Let me know if any things is wrong.
Thanks & Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / baswaraj
take a normalizer tr and set port vale 2 r 3 how much u
required and drag remaing ports as it is
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ramakrishna
SQ---->AGGR(CREATE O/P PORT AS RCOUNT)WRITE EXPRESSION AS
COUNT(EMPNO)SELECT GROUPBY TO EMPNO
---->ROUTER(GRP1- TRUE)--- TRG1
(GRP2-RCOUNT>1)--TRG2
| Is This Answer Correct ? | 1 Yes | 7 No |
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
how much memory (size) occupied by a session at runtime
Where is metadata stored?
What are the uses of a Parameter file?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
How to view and Generate Metadata Reports?
Please let me know how to make encryption and decryption with example?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
How to partition the Session?
Explain the difference between a data warehouse and a data mart?
Teradata 
