followin source like
region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200
Answer Posted / sree
use java Transformation(through code we can solve this)
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
scenario where i can use only concurrent execution of workflow.
How are indexes created after completing the load process?
Define mapping and session?
Explain why we use partitioning the session in informatica?
What are session parameters ? How do you set them?
Explain about cumulative Sum or moving sum?
Explain the different dimensions.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is joiner change?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the tasks that source qualifier perform?
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?
What is informatica etl tool?