Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
- 3 Answers
- 9809 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / avatar dss42b88
for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure
sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
EXL informatica Questions
How can a transformation be made reusable?
Explain in detail about scd type 1 through mapping.
What is dimensional table?
Different circumstance which drives informatica server to expel records?
I have a flat file, want to reverse the contents of the flat file
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Differences between version 7.x and 8.x.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Is stop and abort are same in informatica?
How can we update a record in the target table without using update strategy?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Implementation methodology
