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
Define joiner transformation?
What is standalone command task?
What is the use of transformation?
What is meant by a domain?
How to load last n records of file into target table - informatica
is it possible to index the data in cache of lkp transformation ?
what is the -ve test case in your project.
What is data transformation manager process?
What is workflow manager?
Where do we use mapping variables in informatica?
Define enterprise data warehousing?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is unit testing?tell me proceedure
How are the sources and targets definitions imported in informatica designer?
Explain how many types of dimensions are available in informatica?