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
- 12504 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sankar
FOR THOSE FLAT FILE WE CREATE A LIST FILE.IN THAT LIST FILE
WE CAN ENTER FLAT FILE DIRECTRIES.
THEN GO TO SESSION
SOURCE TYPE:INDERECT
SOURCE DIRECTOTRY:LIST DIRECTORY
SOURCE FILENAME:LIST.TXT
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
What is mapping debugger?
What is the difference between stop and abort in informatica
What is resilience time?
How to load a Dimension ? and how to load a fact table?
What is the use of source qualifier?
Describe data concatenation?
draw informatica architecture 8.6 ?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is a snowflake schema?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to open an older version of an object in the workspace?
Explain what is informatica metadata and where is it stored?
Different qualification between a related rotate toward the sky and isolates look upward?
Differentiate between source qualifier and filter transformation?
