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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to delete duplicate row using informatica?
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)
server hot-ws270 is connect to Repository B. What does it mean?
What is exclusive and normal mode for repository services?
Explain the different dimensions.
What is the Rank index port in Rank transformation?
How to extract the informatica rejected data?
Explian the Process of deployment groups in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the new features of Power Center 5.0?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the difference between informatics 7x and 8x and what is latest version?
