Interested to Buy Any Domain ? << Click Here >> for more details...
Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
- 7 Answers
- 15272 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ahalyabest@gmail.com
SQ---> SEQ GEN---> EXP--> ROUTER---> TRG1, TRG2, TRG3, TRG4
in seq generator properties
start value-1
increment value-1
end value-4
current value-1
cycle-true
reset-true
in router conditions
4 conditions
group 1= iif ((nextval=1)1,0)
group 2=iif (( nextval=2)1,0)
group 3=iif((nextval=3)1,0)
group 4=iif((nextval=4)1,0)
connect
group1-->target1
group2-->target2
group3-->target3
group4-->target4
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
In warehouses how many schemas are there?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain dynamic target flat file name generation in informatica
What is source qualifier transformation in informatica?
list out all the transformations which use cache?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to elaborate tracing level?
What is Session and Batches?
Why update strategy and union transformations are active?
What is an aggregator transformation?
What are the different clients of powercenter?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have a flat file, want to reverse the contents of the flat file
