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
- 14476 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi,,,TCS,,,
Have you attend Recently for TCS,,,?
You need to load 10flatfiles to One relational source,,?
You can keep 10flat files in a single folder.Just assign
the folder path as a Source path in SESSION PROPERTIES.
it will make it 1 flatfile source.
By a simple Mapping,make it single Relational source.
Any corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
What is meant by target load plan?
define galaxy repository in informatica
Explain why we use partitioning the session in informatica?
What is a code page?
What is a standalone command task?
Mention few advantages of router transformation over filter transformation.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
State the differences between sql override and lookup override?
Do you find any difficulty while working with flat files as source and target?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How many ways a relational source definition can be updated and what are they?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the measure objects?
