Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
- 5 Answers
- 11416 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anu
sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=300
currval=1
cycle check it save it.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / anu
take sequence generator connect neval port to router
in router create 3 groups
in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1
in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2
in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / ramana sreepathi
Take sequence generator connect nextval port to router
in router create 2 groups
in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2
in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3
in default group
trg3
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajay konidena
1st answeris correct but for this logic we do use number
of ' or ' operater and code becom big so thire is on
solution that in sequence genarater t/f thire is one
option that cyclic as in oracle sql .
by using this option and router we can do this
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anu
in above answer i given reverse conditions ..just modify conditions
but i think logic corrct
| Is This Answer Correct ? | 0 Yes | 1 No |
tell me 7.x and 8.x diferrencess(but not transformations)
Explain the scenario which compels informatica server to reject files?
what are cost based and rule based approaches and what is the difference?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
What do you mean by filter transformation?
what is the difference between Informatica7.1 & informatica 8.1
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Name the different lookup cache(s)?
how to join the two flatfiles using the joiner t/r if there is no matching port?
What differs when we choose the sorted input for aggregator transformation?
what is the process we used in joiner transformation,there is no matching column in sources?
Teradata 
