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
- 9275 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 |
Define the various join types of joiner transformation?
which quality process u can approach in ur project
How to create Target definition for flat files?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are Target Options on the Servers?
What are mapplets?
performance wise which one is better in joiner and lookup transformation
Can we get 1st record through Informatica(without sequence number).
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is operational data source (ODS)?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
Teradata 
