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 |
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What is degenerated dimention table?
Informatica settings are available in which file?
Please let me know how to make Data masking in informatica..
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What do think which one is the better joiner or look up?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
Is there any model difference between ODS and DWH