# Export functionality of Informatica PIM

Hi, Can anyone please tell me how to pass variables in the post processing step of any Export template?
Variables are visible in the dropdown but their values cannot be passed dynamically to any command file for further processing.

##### Post Metadata
- Posted at: about 11 years ago
- Net upvotes: 1


## Comments
### Comment 1

Greetings Mate, 

Muchas Gracias Mi Amigo! You make learning so effortless. Anyone can follow you and I would not mind following you to the moon coz I know you are like my north star.

I came across your problem this was the first solution hits my mind.

Set Lookup cache size based on 3 million records as <a href="https://medium.com/@infamdm02/100-free-informatica-pim-training-the-best-informatica-product-360-tutorial-you-need-796be2816d68"> Nico suggested. </a>
Hold your source data (2 Million in a stage table) in same db. modify lookup query  to validate Exists on stage table

select col1, col2, col3 from Target where exists (select 'X' from source_stage where target.col1=source_stage.col1) and  ...........

That will limit your cache size to max 2-3 Million. Rest of logic you can hold as it is.

Appreciate your effort for making such useful blogs and helping the community. 

Shukran, 
Sanjay


##### Comment Metadata
- Posted at: almost 8 years ago
- Author title: Senior Technical Recruiter at Prosper




## Related Product
[Informatica MDM – Product 360](https://www.g2.com/products/informatica-informatica-mdm-product-360/reviews)

## Related Category
[Product Information Management (PIM)](https://www.g2.com/categories/product-information-management-pim)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4