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
- 13860 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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the commit type if you have a transaction control transformation in the mapping?
What is the function of look up transformation?
Did u used latest transformations of 8.6.0? for what?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the mapping variable usage example in informatica
Tell me about Propagate functions in informatica
What is a pre-defined event and user-defined event?
How to join three sources using joiner? Explain though mapping flow.
Different circumstance which drives informatica server to expel records?
What is mapplet in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain sql transformation in script mode examples in informatica
