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
- 9759 Views
- Mind Tree, I also Faced
- E-Mail Answers
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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
can u give example for factless fact table
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is main use of mapplet?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How many dimensions are there in informatica?
Is it possible to revert a global repository to local one and why?
How do you load first and last records into target table?
Why update strategy and union transformations are active? Explain with examples.
What are the issues you have faced in your project? How did you overcome those issues?
Design a mapping to load a target table with the following values from the above source?
what is the Default Source Option For Update Strategy Transformation?
Write the prerequisite tasks to achieve the session partition?
What is Session and Batches?
