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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can you validate all mappings in the repository simultaneously?
What is Session and Batches?
Which is the t/r that builts only single cache memory?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Under what condition selecting sorted input in aggregator may fail the session?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How many transformations can be used in mapplets.
What is informatica metadata and where is it stored?
What do you understand by a term domain?
Explain the different lookup methods used in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
tell me 5 session failure in real time how can you solve that in your project?
Did u used latest transformations of 8.6.0? for what?
In how many ways we can create ports?