Interested to Buy Any Domain ? << Click Here >> for more details...
i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 10160 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
we can also do it like this
FIRST PIPELINE
From sq connect all the ports to expression t/r and by using sequence generator t/r generate sequence number.
From expression t/r connect the all the ports to the filter t/r write a condition sno=1.
from filter t/r connect all the ports to the target
SECOND PIPELINE
From sq connect all the ports to Aggrigator t/r and dont group by any port,connect the ports to the target
THE DATA FLOW DIAGRAM WILL BE LIKE THIS
sequencegenerator
|
\|/
src--->sq--->expression--->filter--->trg
|
|-->aggrigator--->tgr
I think this will work
| Is This Answer Correct ? | 12 Yes | 1 No |
Please try the SQL query in the SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
if it wrong means please mail to me chandranmca2007@gmail.com
| Is This Answer Correct ? | 8 Yes | 3 No |
Hi Rakesh,
Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / srinivas bolusupati
Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 0 Yes | 0 No |
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
How can you run a session without using server manager?
In warehouses how many schemas are there?
What is an Integration service in Informatica?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Explain constraint based loading in informatica
What is a grid in 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
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Teradata 
