5 Replies Latest reply on Dec 7, 2018 3:55 AM by Damayanti Das

How to get currently processed file name in Informatica cloud not in Power Center

Damayanti Das Nov 27, 2018 12:31 AM

Hi ,

I have a scenario where I need to get currently processed file and from that file I want year part which will be decided to calculate my date key by look up on date dimension table. I was struggling to get this. Could you please help me here to achieve this scenario.

Thanks In Advance

1. Re: How to get currently processed file name in Informatica cloud not in Power Center

Srini Veeravalli Nov 27, 2018 6:50 AM (in response to Damayanti Das)

Refer this and use functions.
https://network.informatica.com/onlinehelp/IICS/prod/CDI/en/index.htm#page/qq-cloud-function-reference/Date_Format_Strin…
Like Show 0 Likes(0)

Actions
2. Re: How to get currently processed file name in Informatica cloud not in Power Center

Damayanti Das Dec 5, 2018 10:28 PM (in response to Srini Veeravalli)

Thanks Srini for the response.

But the question is regarding how do I get Currently processed file name in Informatica cloud. As we have an option in Power center to get "Add Currently processed flat file Name" , Is there any option in cloud to achieve same ?
Like Show 0 Likes(0)

Actions
3. Re: How to get currently processed file name in Informatica cloud not in Power Center

Srini Veeravalli Dec 6, 2018 5:43 AM (in response to Damayanti Das)

one way is using parameter file in that you'll be mentioning the file name and you may refer the variable in the mapping.
I believe that you've multpile source files to process in that case you need to go with command base(Runajobcli) too.
Like Show 0 Likes(0)

Actions
4. Re: How to get currently processed file name in Informatica cloud not in Power Center

Nitin KN Dec 6, 2018 8:29 AM (in response to Damayanti Das)

it's available in 'Fields' tab:
https://network.informatica.com/onlinehelp/IICS/prod/CDI/en/index.htm#page/jj-cloud-transformations/Source_fields.html
Like Show 2 Likes(2)

Actions
5. Re: How to get currently processed file name in Informatica cloud not in Power Center

Damayanti Das Dec 7, 2018 3:55 AM (in response to Nitin KN)

Thanks All for the response. In cloud also we have "Add Currently processed flat file Name" Option to select.
Like Show 0 Likes(0)

Actions

Go to original post

Signing in to Informatica Network

How to get currently processed file name in Informatica cloud not in Power Center

1. Re: How to get currently processed file name in Informatica cloud not in Power Center

2. Re: How to get currently processed file name in Informatica cloud not in Power Center

3. Re: How to get currently processed file name in Informatica cloud not in Power Center

4. Re: How to get currently processed file name in Informatica cloud not in Power Center

5. Re: How to get currently processed file name in Informatica cloud not in Power Center

Actions

More Like This

Legend