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.
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
Explain lookup transformation source types in informatica
Explain the scenario which compels informatica server to reject files?
What is the format of informatica objects in a repository?
How to create or import flat file definition in to the warehouse designer?
What are the differences between source qualifier and joiner transformation?
can u any challenge your project?
What are the tasks that source qualifier perform?
What is lookup transformation?
What is status code in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Is there any target staging area in informatica not staging area
What is the difference between a repository server and a powerhouse?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to update source definition?