Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 13565 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gvk
SQ--->AGG SEQ
SOURCE ----->JOINER---->ROUTER---->TARGET1 AND TARGET2
SQ--->EXP
HERE AGG:1. CT---[O]--->COUNT(EMPNO)
2. NEWPORT---[O]--->1
EXP:1.NEWPORT----[O]---->1
JOINER:NEWPORT(EXP)=NEWPORT(AGG)
ROUTER: GROUP1--->NEXTVAL<=ROUND(CT/2)
GROUP2--->NEXTVAL>ROUND(CT/2)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
How to generate sequence numbers?
What are the measure objects?
Where are the source flat files kept before running the session?
How do you load alternate records into different tables through mapping flow?
What is a passive transformation?
What is the advantage of informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Under what condition selecting sorted input in aggregator may fail the session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a standalone command task?
What does update strategy mean, and what are the different option of it?
How we can create indexes after completing the loan process?
What is event and what are the tasks related to it?
explain about unit testing? in real time?
