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
- 15111 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
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
What is union transformation?
Is there any way to read the ms excel datas directly into informatica?
What are the different components of powercenter?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Enlist some properties of sessions.
what is the hint? how to use it to reduce the query processing in program?
How to call shell scripts from informatica?
How to elaborate tracing level?
Enterprise data warehouse your projects phase by phase explain?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Mention few advantages of router transformation over filter transformation.
explain abt ur project architecture?
What are the tasks that source qualifier perform?
What is the commit type if you have a transaction control transformation in the mapping?
