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 |
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
how we can load rejected record's at run time?(not through bad files)
can you please explain me pre session and post session options?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
How many types of sessions are there in informatica.please explain them?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
What are the types of maping in Getting Started Wizard?
What is a joiner transformation?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
in a table it has 200 rows the query is select 150 from tablename.whats the output
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
How can we eliminate duplicate rows from flatfile,explain?