Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / ajay konidena
1st answeris correct but for this logic we do use number
of ' or ' operater and code becom big so thire is on
solution that in sequence genarater t/f thire is one
option that cyclic as in oracle sql .
by using this option and router we can do this
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How can we handle two sessions in informatica?
can u any challenge your project?
Differentiate between router and filter transformation?
Mention a few design and development best practices for informatica?
What is lookup transformation?
What are the types of caches in lookup?
what is the size of u r source(like file or table)?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Briefly define reusable transformation?
Enlist the differences between database and data warehouse.
How to generate sequence numbers without using the sequence generator transformation?
What is the difference between informatica 7.0 and 8.0?
Explain the tuning lookup transformation - informatica
Why is sorter an active transformation?