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?
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 a grid in Informatica?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
how can u tune u r informatica mapppings
How to eliminate duplicate records in informatica mapping? Explain with an example....
What is the reusable transformation?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
Is informatica power center designer has 64 bit support?
performance wise which one is better in joiner and lookup transformation
Explain the shared cache and re-cache?
Define sessions in informatica etl?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?