how to get max value record into one target and remaining
records into another target?

Answer Posted / swarup

sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain sessions. Explain how batches are used to combine executions?

604


Explain the tuning lookup transformation - informatica

621


Explain dynamic target flat file name generation in informatica

656


Explain Dataware house architecture .how data flow from intial to end?

2133


Is it possible to define a single node as a Gateway node as well as worker node?

665






Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1543


Explain about Informatica server process that how it works relates to mapping variables?

636


How to generate or load values in to the target table based on a column value using informatica etl tool.

619


How can you generate reports in informatica?

590


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1569


What are the types of schemas we have in data warehouse and what are the difference between them?

534


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?

1476


What is event and what are the tasks related to it?

624


Did u used latest transformations of 8.6.0? for what?

1481


What is the meaning of up gradation of repository?

1400