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
- 11440 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 |
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
In a table, 4 person having same salary. How to get Third person record only?
How an expression transformation differs from aggregator transformation?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
How do you join more than 3 flat files in informatica?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
What is a code page?
Under what condition selecting sorted input in aggregator may fail the session?
Teradata 
