i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
Answer Posted / amedela chandra sekhar
IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.
PLZ LET ME IF ANY WRONG
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is resilience time?
How does a rank transform differ from aggregator transform functions max and min?
How will the document be delivered to me?
What does refresh system mean, and what are its distinctive choice?
how many types of dimensions are available in informatica?
What is a filter transformation and why it is an active one?
What are the new features of Power Center 5.0?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Define update strategy?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we override a native sql query within informatica?
What is standalone command task?
Difference between Data and Index Caches?
What do you understand by SOA of Informatica?
Why update strategy and union transformations are active? Explain with examples.