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

Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.

Question Posted / venkadesh

Answer Posted / venkadesh

IT IS NOTHING BUT TEXT DOCUMENT SO WE TAKE AS SOURCE FILE.
AFTER THAT WE LOAD IN SOURCE TABLE. BY CLICKING SOURCE MENU
AND SELECT IMPORT FILE

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to revert a global repository to local one and why?

613

How might you approve all mappings in the archive all the while?

602

What is a filter transformation?

566

wf dont have integration severances how you can run?

1540

How can you increase the performance in joiner transformation?

710




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

639

Explain what are the different types of transformation available in informatica.

573

What are the data movement modes in informatica?

702

Under what condition selecting sorted input in aggregator may fail the session?

663

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1464

What are the different transaction levels available in transaction control transformation?

676

How might one distinguish in the case of mapping is right or not without associating session?

640

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1053

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.

1065

What does role playing dimension mean?

628