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 / 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
Is it possible to create multiple domains on a single Informatica server?
update strategy transformation in informatica
What is meant by active and passive transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is a transaction control transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the use of transformation?
Explain in detail about scd type 1 through mapping.
What does role playing dimension mean?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is the Default Source Option For Update Strategy Transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Differentiate between a repository server and a powerhouse?
What all join we can perform in LOOKUP transformation?
What are the data movement modes in informatica?