how can import the data from the flat files?

Answer Posted / teja_dwh

the file has to be exist in your machine.then import file same
as database table.to import specify the path.

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 node in Informatica?

721


Explain Dataware house architecture .how data flow from intial to end?

2209


What is a surrogate key?

669


difference between repository database and repository service?

709


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777






Difference between Target-based loading and constraint-based loading?

646


State the limitations where we cannot use joiner in the mapping pipeline?

636


What is source qualifier transformation in informatica?

647


What is a transaction control transformation?

854


Write the program through which the records can be updated?

620


What is workflow? What are the components of the workflow manager?

749


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

653


What are the guidelines to be followed while using union transformation?

742


How many types of sessions are there in informatica.please explain them?

776


Explain transaction control transformation in informatica

909