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

in flatfile target how can u create header and footer plese
give me the comands how will u write in session properties

Question Posted / venkat

Answers were Sorted based on User's Feedback



in flatfile target how can u create header and footer plese give me the comands how will u write in..

Answer / raji

tq teja.........but its gud if u gave the answer in a proper n clear way..........
plz let me know the process

Is This Answer Correct ?    2 Yes 0 No

in flatfile target how can u create header and footer plese give me the comands how will u write in..

Answer / ranjan

Please be specific about your requirement. what exactly you want to display in header and footer? So that one can provide you the correct solution.

Is This Answer Correct ?    0 Yes 0 No

in flatfile target how can u create header and footer plese give me the comands how will u write in..

Answer / teja_dwh

by using session properties we can create header and footers
for flat file.
we can take column names as header etc.

reply me if am wrong
teja_dwh@yahoo.com

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

in which situations do u go for scds ?

3 Answers   TCS,

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

How to display First letter of Names in Caps?

7 Answers  

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,




MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories