Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load first and last record from a flat file
source to target?
- 7 Answers
- 29428 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / vinod saini
After sql Trans use AGG,JOINER transformation,and use FIRST
& LAST function in AGG transformation without any group.
FIRST & LAST return the first & Last record values. give
JOINER condition based on first & last.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
Do you find any difficulty while working with flat files as source and target?
Different sorts of metadata that stores in the storage facility?
Plz can any one say me how to get the informatica certification materials and dumps
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Is it possible to use a client with different version than that of its Informatica server?
Parameter and variable differences
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can we create multiple integration service on single repository?
How to delete duplicate row using informatica?
What is rank transformation?
What are the types of schemas we have in data warehouse.
