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
- 13841 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
Name the different lookup cache(s)?
How do you load only null records into target? Explain through mapping flow.
How can we update a record in the target table without using update strategy?
How to do the error handling of if ur source is flatfiles?
What all join we can perform in LOOKUP transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the tasks that can be performed using sq?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to use pmcmd utility command?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a node in Informatica?
Explain lookup transformation is active in informatica
How to create a non-reusable instance of reusable transformations?
Can we create a Integration service without a Repository service and vice versa?
