Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12875 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 |
What is Data Caches size?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Explain direct and indirect flat file loading (source file type) - informatica
Enlist the advantages of informatica.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Why touse stored procedure in ETL Application?
.prm wirh repalce .txt is possible?
in performance wise union is past,union all is past
what is worklet and what use of worklet and in which situation we can use it?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
how to load only the first and last record of a flat file into the target?
Teradata 
