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
- 9790 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
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How might you approve all mappings in the archive all the while?
Explain about cumulative Sum or moving sum?
Different circumstance which drives informatica server to expel records?
What are the types of presistent cache in look up tr.
What is meant by lookup transformation?
What is fact table? Explain the different kinds of facts.
What you know about transaction control transformation?
Enlist few areas or real-time situations where informatica is required.
How can we create index after completion of load process?
Differentiate between router and filter transformation?
How big was your fact table
EXL informatica Questions
scenario where i can use only concurrent execution of workflow.
What is an expression transformation in informatica?
