followin source like
region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200
- 2 Answers
- 4914 Views
- Oracle, I also Faced
- E-Mail Answers
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
What is a joiner transformation and why it is an active one?
What can we do to improve the performance of informatica aggregator transformation?
What are the different options available for update strategy?
Where do we use mapping variables in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the way to execute pl/sql script using informatica mapping?
Informatica Checkpoints
What is aggregate cache in aggregator transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
have u done any performance tuning? how u ll do?
What is informatica powercenter repository?
without table how to come first record only in oracle?
what is the difference between informatica6.1 and infomatica7.1
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
