There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
Answer Posted / bzz
Use source type as Indirect File Type and source file name
as a file having the names of all the n flatfiles to be
read.
Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
differences between service based and product based?
What is fact table? Explain the different kinds of facts.
Different circumstance which drives informatica server to expel records?
What is olap (on-line analytical processing?
What are junk dimensions?
Differentiate between Load Manager and DTM?
How can we handle two sessions in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How do you load unique records into one target table and duplicate records into a different target table?
Why do you use Mapping Parameter and mapping variable?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the function of look up transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?