I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
Answers were Sorted based on User's Feedback
Answer / manthiramoorthy. g
S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3
In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / rucha
i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / gyana
source--->sq--->attached a sequence generator with settings
current value=1
start value=1
end value=3
incrimented by=1
cycle=yes
------->router(3groups)--->3 targets
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / koti
hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...
| Is This Answer Correct ? | 2 Yes | 6 No |
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What are teh different tasks that can be created in workflow manager?
My source table having some records ,i want load 1st record and last record into one target?
What is a configuration management?
What is an incremental loading? in which situations we will use incremental loading
1 lac of flat fles in source how to load target at a time?
What is the sequence generator transformation in informatica?
what are challenges that you faced in testing? give solution to it?
What is rank index in rank transformation?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
How to load query faster,so that It will take less time to load?
What are set operators in Oracle