Interested to Buy Any Domain ? << Click Here >> for more details...
My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9815 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / guest
BY USING FIRST FUNCTION, TO GET THE 1ST RECORD,
TO GET THE LAST RECORD , SIMPLY USE AGGREGATE
TRANSFORAMATION IN THIS DO NOT APPLY GROUP BY FUNCTION BY
DEFALUT IT WILL GENERATE LAST RECORD
OR
USE RANK TRANS
IN =>PROPERTIES NO OF TOP RANKS:1
NO OF BOTTOM RANKS:LAST RECORD
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is an aggregator transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to load a Dimension ? and how to load a fact table?
Which are the different editions of informatica powercenter that are available?
Can we create a Integration service without a Repository service and vice versa?
What are the tasks that source qualifier perform?
Under which circumstances, informatica server creates reject files?
Explian the Process of deployment groups in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What all are steps in up gradation of Informatica server?
What is target load order?
Where do we use mapping variables in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
