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
Explain sessions. Explain how batches are used to combine executions?
Explain the tuning lookup transformation - informatica
Explain dynamic target flat file name generation in informatica
Explain Dataware house architecture .how data flow from intial to end?
Is it possible to define a single node as a Gateway node as well as worker node?
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
Explain about Informatica server process that how it works relates to mapping variables?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How can you generate reports in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the types of schemas we have in data warehouse and what are the difference between them?
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 event and what are the tasks related to it?
Did u used latest transformations of 8.6.0? for what?
What is the meaning of up gradation of repository?