How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 8817 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 |
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
Is it possible to use a client with different version than that of its Informatica server?
What are the different types of Type2 dimension maping?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Where do you create/define mapping parameter and mapping variable?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
In which scenario did you used pushdown optimization?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What is hash partition?
Difference between Data and Index Caches?
Define maping and sessions?
Teradata 
