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 tasks that source qualifier perform?
What is the Rank index port in Rank transformation?
Differentiate between joiner and lookup transformation?
What is complex mapping?
How does a sorter cache works?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain what are the different types of transformation available in informatica.
What do you understand by term role-playing dimension?
What are the different versions of informatica?
Informatica Checkpoints
Separate from an archive server and a powerhouse?
what are 3 tech challenges/ common issues you face?
How many ways are there to create ports?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance