following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
Answers were Sorted based on User's Feedback
Answer / suresh
Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router
Is This Answer Correct ? | 10 Yes | 1 No |
Hi suresh you are 50% current
sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3
drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes
later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3
first group connect to T1
second group connect to t2
third group connect to t3
is 100% correct
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / venkat
->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / triveni
startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0
Is This Answer Correct ? | 0 Yes | 0 No |
How to load the source table into flat file target(with columns) in informatica?
where to store informatica rejected data?
How informatica recognizes mapping?
What is rank transformation in informatica
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
How does the aggregator transformation handle null values?
How can we update a record in the target table without using update strategy?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Is it possible to have "5 source & 5 Target" in single mapping?