{
    "name": "Blob_SQL_PL",
    "properties": {
        "activities": [
            {
                "name": "If_Condition_AC",
                "type": "IfCondition",
                "typeProperties": {
                    "expression": {
                        "value": "@bool(startswith(pipeline().parameters.SourceFile,'FactIntSales'))",
                        "type": "Expression"
                    },
                    "ifFalseActivities": [
                        {
                            "name": "DimCurrency_AC",
                            "type": "Copy",
                            "policy": {
                                "timeout": "7.00:00:00",
                                "retry": 0,
                                "retryIntervalInSeconds": 30,
                                "secureOutput": false,
                                "secureInput": false
                            },
                            "typeProperties": {
                                "source": {
                                    "type": "BlobSource",
                                    "recursive": true
                                },
                                "sink": {
                                    "type": "SqlSink",
                                    "writeBatchSize": 10000
                                },
                                "enableStaging": false
                            },
                            "inputs": [
                                {
                                    "referenceName": "BlobSTG_DS2",
                                    "type": "DatasetReference",
                                    "parameters": {
                                        "FileName": "@pipeline().parameters.SourceFile"
                                    }
                                }
                            ],
                            "outputs": [
                                {
                                    "referenceName": "DimCurrency_DS",
                                    "type": "DatasetReference"
                                }
                            ]
                        }
                    ],
                    "ifTrueActivities": [
                        {
                            "name": "FactInternetSales_AC",
                            "type": "Copy",
                            "policy": {
                                "timeout": "7.00:00:00",
                                "retry": 0,
                                "retryIntervalInSeconds": 30,
                                "secureOutput": false,
                                "secureInput": false
                            },
                            "typeProperties": {
                                "source": {
                                    "type": "BlobSource",
                                    "recursive": true
                                },
                                "sink": {
                                    "type": "SqlSink",
                                    "writeBatchSize": 10000,
                                    "preCopyScript": "Delete from FactInternetSales"
                                },
                                "enableStaging": false
                            },
                            "inputs": [
                                {
                                    "referenceName": "BlobSTG_DS2",
                                    "type": "DatasetReference",
                                    "parameters": {
                                        "FileName": {
                                            "value": "@pipeline().parameters.SourceFile",
                                            "type": "Expression"
                                        }
                                    }
                                }
                            ],
                            "outputs": [
                                {
                                    "referenceName": "FactInternetSales_DS",
                                    "type": "DatasetReference"
                                }
                            ]
                        }
                    ]
                }
            }
        ],
        "parameters": {
            "SourceFile": {
                "type": "String"
            }
        }
    },
    "type": "Microsoft.DataFactory/factories/pipelines"
}