How to load only the first and last record of a flat file into
the target?
Answer Posted / 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 |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How do you update the records with or without using update strategy?
What are multi-group transformations?
What is the function of look up transformation?
How to create or import flat file definition in to the warehouse designer?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Implementation methodology
How can we improve session performance in aggregator transformation?
How to generate sequence numbers using expression transformation?
How to extract sap data using informatica?
How can we use mapping variables in informatica?
Write the prerequisite tasks to achieve the session partition?
update strategy transformation in informatica
What is main use of mapplet?