in flatfile target how can u create header and footer plese
give me the comands how will u write in session properties
Answer Posted / 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 View All Answers
What is the fact table?
What are ETL Tools?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
design of staging area?
What is update strategy transform?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain incremental aggregation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What can we do to improve the performance of informatica aggregator transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is olap (on-line analytical processing?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is flashback table ? Advance thanks
What are the informatica performance improvement tips