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
Explain sessions and how many types of sessions are there?
Explain the different dimensions.
lookup transformation with screenshots
what is SDLC way of code development?
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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the new features of informatica 9.x at the developer level?
What is powercenter on grid?
Define filter transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
have u done any performance tuning? how u ll do?
what is unit testing?tell me proceedure
During the running session, output files are created by informatica server. Enlist few of them.