top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Need help on Informatica Scenario

+2 votes
407 views

I need your help. I have to work on two scenarios -

There is a informatica workflow WF1 which we need to invoke at 8PM. This worflow will look for a file (ETL.txt) and if this file will not come in another 1hour (9PM), then it will get fail and send mail to support person.If file come on time, then it will run.

In a mapping the source flat file's field separator is comma (,) and if tomorrow this field separator get change to pipe (|), then how we can accomodate the change in worfkow. Is it a way that dynamically we can identity the flat file field separator?

Thanks in advance.

posted May 23, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Look for the file through unix script and pass the value of the same to the workflow.Based on the result,you can move

answer May 26, 2014 by Shweta Singh
0 votes

Scenario 1 :- Better to execute the workflow at 9:00 PM and attach an -email task after that session. Check the status of the session if not succeeded then trigger the e-mail to support person.

Scenario 2 :- As per my knowledge we can't change it dynamically. It would be better to identify the data which will be processed and accordingly choose the separator. You can take two separator like ',|' to make it perfect.

answer Jun 11, 2014 by Shatark Bajpai
Similar Questions
+1 vote

Hi All ,

This is Bharat . Can somebody help me here to implement cume_dist() over(order by sal desc) in informatica with out using source qualifier .I need it immediately .

Warm Regards,
Bharat

0 votes

In my case, i have an expression transformation which uses the default function ERROR('transformation') to skip the records in which date value coming inside is not in the correct format. In this, the skipped rows are not written to the reject files, so that we are getting the reconcilation problem. I need the skipped rows to be written to the bad files.Please help me how can i achieve this.

+1 vote

I am new to Informatica

I have one staging table where data comes everyday and I need to extract data from this staging table and convert it into Dat file format and place in into a folder. so that these dat files could be a feed for another process.

I dont know how informatica does this (Conversion of data from Staging table to Dat). So please help me to know how Informatica fetch the data from staging table, transform it into Dat file and place it into a folder.

...