how we can add header and footer to flat files?
Answers were Sorted based on User's Feedback
Answer / sidhu
in session properties,
select mapping tab then
select target properties
there header and footer command option
there u give
echo header in header option
and echo footer in footer option
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mukesh kumar
go to session edit>>>>mapping tab>>>>>>>selct
source>>>>>>in header command option and footer command
option type the command
| Is This Answer Correct ? | 7 Yes | 4 No |
What is query panel?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
How many joins in Informatica
How will you check the bottle necks in informatica? From where do you start checking?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
how to join the 2 different table with different columns in informatica?
How will you update the row without using update statergy?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What are the data movement modes in informatica?
what is scd?