Interested to Buy Any Domain ? << Click Here >> for more details...
Can you create a flatfile target
- 3 Answers
- 4040 Views
- ABC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nikita jain
yes, In Target design tab of Designer there are options like import from flatfiles also create table there we can select the type as flat file.
we can add the column names after creating the flatfile target instance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Which transformation is needed while using the Cobol sources as source definitions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What is rank index in rank transformation?
Explain the aggregator transformation?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
What is aggregate cache in aggregator transformation?
What is the benefit of session partitioning?
How can u work with remote database in informatica?did you work directly by using remote connections?
How can a transformation be made reusable?
Teradata 
