I have the input file as
col1 col2 col3
3 2 1
7 6 8
I should get the output as
col1 col2 col3
1 2 3
6 7 8 ....What is the logic to get this? Is there any
transformation which sorts row wise ? If not how to sort
the incoming records row wise?
- 5 Answers
- 8631 Views
- I also Faced
- E-Mail Answers
Answer Posted / raja
There is no logic for this.You should try to be smart by
asking the useless question.try to ask some question which
will be useful for others.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is an unconnected transformation?
What do think which one is the better joiner or look up?
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
What is complex mapping?
can we override a native sql query within informatica? How do we do it?
Parameter and variable differences
Design time, run time. If you don't create parameter what will happen
Write the prerequisite tasks to achieve the session partition?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the types of lookup transformation?
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.
which one is better performance wise joiner or look up
What is deployment group?
what are the Methods For Creating Reusable Transformations?
