Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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??

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


Please Help Members By Posting Answers For Below Questions

What is enterprise data warehousing?

1055


tell me 5 session failure in real time how can you solve that in your project?

2308


Why union transformation is an active transformation?

1053


Different circumstance which drives informatica server to expel records?

992


How is union transformation utilized?

1016


Differentiate between reusable transformation and mapplet.

1105


What is a repository manager?

1099


Did u used latest transformations of 8.6.0? for what?

1887


Which is the t/r that builts only single cache memory?

1195


Enlist the various types of transformations.

1066


What is target designer and target load order?

1116


Design time, run time. If you don't create parameter what will happen

1842


What is DR strategy for Informatica project?

1195


What is olap (on-line analytical processing?

1077


What are the advantages of using informatica as an etl tool over teradata?

1029