Answer Posted / shweta
When we use Flat file as a source we give the path of
directory where we store the file in Workflow.
But if we want data from multiple flat files then we put
the names of all flat files in a single file called as file
list.
In workflow mapping we give the path of list file and mark
the source filetype as INdirect as we are indirectly
accessing all the flat files.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
What does role playing dimension mean?
tell me 5 session failure in real time how can you solve that in your project?
Explain how to import oracle sequence into informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain the shared cache and re-cache?
What are the differences between joiner transformation and source qualifier transformation?
what is informatica metadata?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is aggregate cache in aggregator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Please let me know how to make encryption and decryption with example?
What is the difference between source qualifier transformations source filter to filter transformation?
What is a repository? And how to add it in an informatica client?