Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
Answer Posted / santosh kumar sarangi
1.Take a sequence generator and connect it to the expression
t/r.
2.In expression transformation create a out put post and
keep the below condition;
VAL_OUT = iif(mod(floor((nextval-1)/10),2)=0,0,1)
3.Keep a router t/r, and filter with the condition VAL_OUT=0
then first target and if VAL_OUT=1 then second target.
Let me know if any thing wrong.
Thanks & Regads
Santosh Kumar Sarangi
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Can anyone tell me the new features in Informatica 9 Version?
Write the prerequisite tasks to achieve the session partition?
How to update a particular record in target with out running whole workflow?
What is an Integration service in Informatica?
How we can use union transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is meant by LDAP users?
What is a shortcut and copy in Informatica and how two are different with each other?
Enlist the various types of transformations.
Write the program through which the records can be updated?
What if the source is a flat-file?
what is index?how it can work in informatica
what is the -ve test case in your project.