1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 / subhrajit

Answers were Sorted based on User's Feedback



There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / 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

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / srinu

Yes BZZ,,,

After assign the folder path in Source path,
We have to change source Type as INDIRECT in Session
properties.

Is This Answer Correct ?    12 Yes 0 No

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / amarnath

create a file list which is nothing but simple .txt file
which contains the name of the each file u want to load and
in session properties make source file as "indirect" and
give the path of the file list that u have created and run
the wkf

Is This Answer Correct ?    5 Yes 0 No

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / 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

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / 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

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / harish konda

Yes we can load all these flat files in a single session.

First create a txt file and in that give all the file names
along with their PATH.

Drag any one of the flat file into the mapping and link it
to the target acc. to your requirement.

And in the session properties give the file type as Indirect
and in Filename option, give the file name(along with the
path) of the file in which you gave all the paths.

Then run the mapping.

Is This Answer Correct ?    1 Yes 0 No

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / ravi

not folder.we have mention folder fath

Is This Answer Correct ?    0 Yes 3 No

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / 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

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these ..

Answer / rekha

YES YOU CAN DO IT BY USING FILE REPOSITORY
U CAN PLACE THAT FOLDER IN THE SESSION PROPERTIES

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Informatica Interview Questions

Difference Between ETL & ELT?

1 Answers   TCS,

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

Explain the difference between mapping parameter and mapping variable?

0 Answers  

Can u generate reports in Informatica?

0 Answers   Informatica,

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,




wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

What is meant by query override?

0 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

what is incremental data aggregation?

3 Answers   IBM,

Explain the different dimensions.

0 Answers  

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

For more Informatica Interview Questions Click Here
Categories