Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9807 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / spandita
After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / harish konda
First connect the exp1 with source and Sequence t/f's.
And next take the sorter and sort the data in descending
order of NEXTVAL port.
And again connect sorter to exp2 and connect sequence t/f to
this exp2.
And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.
| Is This Answer Correct ? | 0 Yes | 0 No |
wf dont have integration severances how you can run?
Can I create one wrkflw which will run different wrkflws on schedule time?
What are the out put files that the informatica server creates during the session running?
How might you approve all mappings in the archive all the while?
What are the Advantages of de normalized data?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the Rank index port in Rank transformation?
Whatis the difference between View and Materialized View ?
Teradata 
