Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 13810 Views
- L&T, I also Faced
- E-Mail Answers
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
Define sessions in informatica etl?
Explain the informatica workflow?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is target designer and target load order?
How will the document be delivered to me?
Explain scd type 3 through mapping.
What is deployment group?
Explain lookup transformation is active in informatica
Explain direct and indirect flat file loading (source file type) - informatica
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the use of an aggregator cache file?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
