Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
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
How to load last n records of file into target table - informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is an expression transformation in informatica?
Describe expression transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is option by which we can run all the sessions in a batch simultaneously?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is dimensional table? Explain the different dimensions.
define galaxy repository in informatica
What is powercenter on grid?
have u done any performance tuning? how u ll do?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
State the limitations where we cannot use joiner in the mapping pipeline?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is aggregator transformation in informatica?