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
can u any challenge your project?
How can we create index after completion of load process?
Describe the impact of several join conditions and join order in a joiner transformation?
While migrating the data from one environment to another environment how would you manage the connections?
What is resilience time?
What is sq transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Is it possible to use a client with different version than that of its Informatica server?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How can we use mapping variables in informatica? Where do we use them?
Explain what transformation and how many are there in informatica?
What is main use of mapplet?
Difference between Data and Index Caches?
Could you explain what is enterprise data warehouse?