how to connect to a flatfile through ftp in informatica
- 1 Answers
- 13756 Views
- TCS, I also Faced
- E-Mail Answers
Answer / sri
Create FTP connection in workflow manager. In
session->mapping, assign created ftp connection to
source(flat file).
| Is This Answer Correct ? | 10 Yes | 2 No |
what is session partitioning?
When do we analyze the tables?
how do u set partition points in the mapping?
What is factless fact schema?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what is SMP AND MPP?
what is session partitioning?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
What are your responsibilities as an etl tester?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
Explain the difference between etl tool and olap tools?
Teradata 
