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
What are the different types of transformation available in informatica.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is mapping debugger?
How to update source definition?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Different sorts of metadata that stores in the storage facility?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain pushdown optimization and types in informatica
What are the types of data warehouses?
What are the tasks that source qualifier perform?
How do you update the records with or without using update strategy?
What differs when we choose the sorted input for aggregator transformation?
How can we delete duplicate rows from flat files?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.