I'd like the load to be triggered by client. By placement
of a file or somehow. How is it done in Informatica? I'm
using version 7.1.4
This is so urgent - I really appreciate your help :-)
Answer Posted / lakshmi
you could use an event wait task in the workflow as the
first task. Once the event wait task detects the file in
the specified folder all other sessions tasks wil run.
alternatively you could use unix commanda in the command
task.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What's the layout of parameter file (what does a parameter file contain?)?
Could you explain what is enterprise data warehouse?
list out all the transformations which use cache?
What are the restrictions of union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to do unit testing in informatica?
How to extract the informatica rejected data?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the prerequisite tasks to achieve the session partition?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
can we override a native sql query within informatica? How do we do it?
In development project what is the process to follow for an etl developer from day1
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Enlist some properties of sessions.