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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Why do you use Mapping Parameter and mapping variable?
Can anyone tell me the new features in Informatica 9 Version?
What is informatica? Why do we need it?
Differentiate between a repository server and a powerhouse?
Explain what are the different types of transformation available in informatica.
Explain what is informatica metadata and where is it stored?
Whats the difference between informatica powercenter server, repositoryserver and repository?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
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 are the popular informatica products?
What is standalone command task?
How to create Target definition for flat files?
What is joiner transformation?
What is the use of code page?