Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 7 Answers
- 15075 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
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 update source definition?
What is meant by LDAP users?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Does an informatica transformation support only aggregate expressions?
4 yrs etl devloper roles and responsibilities?any body give solutions
Could you explain what is enterprise data warehouse?
What is incremental aggregation?
What is the need of etl tools?
What are the different types of repositories created using informatica?
what is song in infrmatica...?
What are the types of data warehouses?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can we improve session performance in aggregator transformation?
What is the use of transformation?
What is a passive transformation?
