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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

explain one complex mapping with logic? sales project?

6289


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3622


In informatics server which files are created during the session rums?

733


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1233


What is informatica worklet?

701






What do you understand by SOA of Informatica?

668


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1708


What is depict expression change?

707


4 yrs etl devloper roles and responsibilities?any body give solutions

1690


Implementation methodology

1348


How to differentiate between the active and passive transformations?

711


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1956


Can we create a node as a gateway node and the same node can be assigned to a grid?

727


What are the tasks that can be performed using sq?

693


Write the program through which the records can be updated?

621