i need to import the data from excel files in Informatica. I have created a ODBC connection to bring this in as a source. But I need to define a 'name' in the excel to consider that as a table to import. Is there any way where I can import the excel without defining a name in the excel i.e. only by referring the file name of excel. Thanks.
Import excel into Informatica
428 Views Asked by Robin clave At
1
There are 1 best solutions below
Related Questions in INFORMATICA
- Impact of PRE-SQL and POST -SQL on Push Down Optmisation in IICS
- Scheduling Informatica IICS taskflow
- Running 2 stored procedures in post SQL for Informatica
- Subtaskflow is getting suspended instead of failed in IICS
- Instr to find the exact pattern match in informatica
- Ho to change existing MD5 checksum value to make it different from previous value
- Informatica new line and carriage return
- Unable to read the JSON array element data from event based kafka topic message connection in IICS/IDMC
- REG_MATCH function in Informatica - Identify a pattern
- Return all records in Salesforce TASK table with Informatica
- Informatica Powerexchange post sql greenplum writer
- Replace SAS stored process with different ETL tool
- is there any open source tool to migrate informatica Etl Script to Aws glue?
- PMCMD Command to get session statistics Informatica
- how to handle chinese characters in teradata
Related Questions in INFORMATICA-POWERCENTER
- How to convert ansii file to utf-8 encoded file through informatica workflow?
- How to match the values generated by MD5 hash (Informatica) and Standard hash (Oracle)?
- Subtaskflow is getting suspended instead of failed in IICS
- Instr to find the exact pattern match in informatica
- Ho to change existing MD5 checksum value to make it different from previous value
- Informatica new line and carriage return
- Unable to read the JSON array element data from event based kafka topic message connection in IICS/IDMC
- Affected rows from seesion logs does not reflect in actual target table in Informatica
- Sequence-id in associated expression for dynamic lookup in Informatica Powercenter
- how to lookup on a table based on a null key in informatica powercenter
- PMCMD Command to get session statistics Informatica
- can we use informatica power center to load into teradata cloud?
- Informatica Incremental Load using greenplum writer
- How to call APIs in Informatica Powercenter
- how to create ETL to dynamically get the port name
Related Questions in EXCEL-IMPORT
- R code for reading Excel in character format
- Unable to Load an xlsm file onto an existing excel workbook(.xlsx) with the help of SpreadJS using OfficeJS
- php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" BadMethodCallException
- How to import datawarehouse to excel without using odbc?
- Python Excel Pandas DataFrame Import - Handling nested (and merged) headers
- MS Project get Taskdependencies property via Excel VBA
- SQL Server OPENROWSET Msg 7302 Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
- (PhpOffice\\PhpSpreadsheet\\Reader\\Exception(code: 0): Could not find zip member laravel queues job - Laravel
- Microsoft query in Excel returning a blank column when SSMS does not
- Adding Additional Parameter to Excel Import in Rails
- Laravel Excel Import: "Attempt to read property \"id\" on null"
- foreclosure.com get data from web to excel multiple pages in single sheet
- Reading formdata binary excel in nodejs
- Showing error "Invalid date value" while importing excel file in Laravel 7
- Can I Import Results From Excel Into Test Rail?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Unfortunately not. You can use Excel as a source only with a named range.