Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14118 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / schwab
Hi,
Yes U can do it by merging all 10 flat files in one single
file.
create a script before session(presession) to merge all
these files into one.
This is the way we are handling in our project.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How many transformations can be used in mapplets.
What are the components of workflow manager?
What is data transformation manager process?
What is a shortcut and copy in Informatica and how two are different with each other?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is an Integration service in Informatica?
What is the use of an aggregator cache file?
What is repository manager?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain lookup transformation source types in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is pmcmd command?
What is primary and backup node?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
