How to load the source table into flat file target(with
columns) in informatica?
Answer Posted / ankit kansal
Hi,
Go to session properties and then select target instance from mapping there you will find an option where by default no header is selected just use output field names to provide your mapping column names or you can use command option to manually define your column.
Use echo col1,col2 to provide manual column names while selecting header command option.
http://www.allinterview.com/showanswers/122611.html
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Briefly explain the aggregator transformation?
What are multi-group transformations?
What is InformaticaPowerCenter?
How many ways are there to create ports?
What is data transformation manager process?
How you can differentiate between connected lookup and unconnected lookup?
hi real timers . iam waiting for ur reply regarding ETL TESTING
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to partition the Session?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the components of the workflow manager?
4 yrs etl devloper roles and responsibilities?any body give solutions
How you know when to use a static cache and dynamic cache in lookup transformation?