I have 2 Sources,If 1st one Read sucessfully,Then only it
has to move to read 2nd source.How can i do in INFORMATICA.
- 4 Answers
- 9319 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaspreet banga
For this we have to make 2 different sessions for each
source reading after the success of first session(i.e.,
succesful reading of 1st source ) , create a 'TOUCH FILE'
using 'command task' and link it with the session, hence
the touch file is only created if the session is
succesful . and at the beginning of another session(reading
second source) create an 'EVENT WAIT TASK' which will only
triggered when touch file is created. and hence you will
get it..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to implement security measures using repository manager?
What could be the possible resons of locks by user?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is joiner transformation in informatica?
What is a node in Informatica?
what is the complex transformation you used in informatica
What is the cumulative sum and moving sum?
What are the new features of informatica 9.x at the developer level?
What is complex mapping?
What is event and what are the tasks related to it?
How can you validate all mappings in the repository simultaneously?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain what are the different versions of informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
