Are there valid records in the dataset i.e. there is at least one record without IGNORE in the intersection? Does anything get loaded to Planning? What does the log say?
Yes, there are valid records in dataset.
Log file -
2016-11-28 00:14:58,762 INFO [AIF]: Total Data Rows available for Export to Target: 7779
2016-11-28 00:14:58,934 DEBUG [AIF]: app id:27, app type:HPL, multiCurrencyFlag:true, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL
2016-11-28 00:14:58,934 INFO [AIF]: LOAD_METHOD:ESSFILE, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, BATCH_SIZE:10000, PREFIX_DIM_DUPLICATE_MEM:true
2016-11-28 00:14:58,934 DEBUG [AIF]: GlobalUserForAppAccess from Profile: admin
2016-11-28 00:14:58,934 INFO [AIF]: Cloud Mode: NONE, Resolved user name for application access: admin
2016-11-28 00:15:01,746 DEBUG [AIF]: updateMultiCurrencyProperties - BEGIN
2016-11-28 00:15:06,996 DEBUG [AIF]: Currency Properties Exist for Planning Application: FPACORP
2016-11-28 00:15:06,996 DEBUG [AIF]: Number of existing multi-currency property rows deleted: 123
2016-11-28 00:15:06,996 DEBUG [AIF]: Base Currency for Application: USD
2016-11-28 00:15:07,199 DEBUG [AIF]: Number of multi-currency property rows inserted: 123
2016-11-28 00:15:07,199 DEBUG [AIF]: updateMultiCurrencyProperties - END
2016-11-28 00:15:07,231 DEBUG [AIF]: Obtained connection to essbase cube: PnL
2016-11-28 00:15:07,231 DEBUG [AIF]: ACCOUNT,ENTITY,UD1,UD2,UD3,UD4,CURRENCY,SCENARIO,YEAR,PERIOD,HSP_Rates,AMOUNT
WHERE LOADID = 6436
2016-11-28 00:15:07,231 INFO [AIF]: Creating data file: \\EPMSYSD\Oracle\FDMEE\FPACORP/outbox/FPACORP_6436.dat
2016-11-28 00:15:11,668 INFO [AIF]: Data file creation complete
Import, Validate and export stages are successful, there are no errors in log file.
There are valid rows for export, but a blank file is getting generated.
Target is multi-currency planning application, source is Teradata table loaded through open interface source type.
what do you get when you run sql query?
SELECT * from AIF_HS_BALANCES_HPL_MC_V where loadid = x
x is your loadid