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??
- 9 Answers
- 11899 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain lookup transformation source types in informatica
What is dimensional table? Explain the different dimensions.
Explain sessions. Explain how batches are used to combine executions?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Tell me about MD5 functions in informatica
How to handle decimal places while importing a flatfile into informatica?
What do think which one is the better joiner or look up?
update strategy transformation in informatica
Describe expression transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the differences between a connected lookup and unconnected lookup?
Explain the shared cache and re-cache?
what is degenerated dimension?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is the Default Source Option For Update Strategy Transformation?
