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
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 ?||16 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
|Is This Answer Correct ?||6 Yes||4 No|
Answer / gyana
source--->sq--->attached a sequence generator with settings
|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|
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What are the phases in SDLC?
what is mean by flag 4 in update strategy t/r
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
what is the exact meaning of domain?
Can we create a node as a gateway node and the same node can be assigned to a grid?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What the difference is between a database, a data warehouse and a data mart?