Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 9713 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / informatica
use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Write the unconnected lookup syntax and how to return more than one column.
What is rank transformation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Differences between version 7.x and 8.x.
What are the types of caches in lookup?
What is different between the data warehouse and data mart?
Enlist the various types of transformations.
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's the layout of parameter file (what does a parameter file contain?)?
What is the reusable transformation?
How can repository reports be accessed without sql or other transformations?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the need of an ETL tool?
