how to import multiple flat files in to single target where
there is no common column in the flat files
- 2 Answers
- 6783 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ramana sreepathi
in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>
This <file_path> file should contain all the multiple files
which you want to Load
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what are 3 tech challenges/ common issues you face?
Explain pushdown optimization $pushdownconfig parameter - informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the static cache and dynamic cache in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to handle decimal places while importing a flatfile into informatica?
What is a router transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can you generate sequence numbers without using the sequence generator transformation?
How do you promote a non-reusable transformation to reusable transformation?
What are Dimensional table?
Explain joiner transformation in informatica
