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 deployment group?
Is stop and abort are same in informatica?
How do you convert single row from source into three rows into target?
What are junk dimensions?
What are the data movement modes in informatica?
draw informatica architecture 8.6 ?
What are the differences between oltp and olap?
What is the fact table?
What is the difference between a repository server and a powerhouse?
State the differences between sql override and lookup override?
Explain the tuning lookup transformation - informatica
How do you load only null records into target? Explain through mapping flow.
What are the designer tools for creating transformations?
my source is junk data how will u remove that junk data by using unix please any one replay me
How can we remove the duplicates from flat file source?