How to add source flat file header into target file?

Answers were Sorted based on User's Feedback



How to add source flat file header into target file?..

Answer / raju potla

When we use target as a flatfile then in the mapping tab of
a session click the flatfile target then we have an header
option , in that select output field names

Is This Answer Correct ?    6 Yes 1 No

How to add source flat file header into target file?..

Answer / sehaj

IN 7/8 WE CAN GO TO SERVER SETUP N CHOOSE A PROPERTY FROM THERE WHERE READS AS
"CREATE METADTA FOR FLAT FLIE"

IN 8.6 WE CAN SET ITIN SESSION PROPERTIES...OPEN SESSION PROPERTIS
THEN IN TARGET CHOOSE THE HEADER PROPERTY WHERE V DEFINE THE PATHNAME N ALL FOR THE FLAT FILES.

Is This Answer Correct ?    3 Yes 2 No

How to add source flat file header into target file?..

Answer / venkatanarayana manam

First Open the session which contains source/target as Flat file edit the mapping tab-->properties-->Enable Add Currently Processed Flat File Name Port

If selected, a port specifying currently processed file name will be added to the source widget.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


How to elaborate tracing level?

0 Answers  


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


What is workflow manager?

0 Answers  


hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


What are conformed dimensions?

1 Answers  


Categories