Hi, Yes U can do it by merging all 10 flat files in one single file. cr

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??

Question Posted / schwab

9 Answers
14499 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

Please Help Members By Posting Answers For Below Questions

What is a filter transformation and why it is an active one?

971

Can u generate reports in Informatica?

1094

Explain lookup transformation in informatica

1081

Can we create multiple integration service on single repository?

1197

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1016

What are the new features of informatica 9.x in developer level?

1002

What will be the approach?

991

What is decode in informatica?

1170

Define update strategy?

1235

where to store informatica rejected data? How to extract the informatica rejected data?

1008

How will the document be delivered to me?

1086

What is expression transformation?

1108

how to load dimension table and fact table. plz tell me the steps.

2096

How to use procedural logic inside infromatica?

1250

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2125