i have a source of n records.i have to load n+5 records to my
target.What is the procedure??????plz tell me.....
- 1 Answers
- 4526 Views
- I also Faced
- E-Mail Answers
Answer / srikanth
try below mapping in mapping designer
source->sourcequalifier->exptf1->trg( for n records)
->exptf2(with
sequencegtf)->routertf(sequence column=1 AND
5)->trginstance(same above trg)
Finally you will get total n+5 records into target. Here i
used only one target. just i taken instance.
It will work..
| Is This Answer Correct ? | 1 Yes | 0 No |
What is difference between Mapplet and reusable transformation?
How will the document be delivered to me?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the different types of olap? Give an example?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
Hi experts, can anyone tell how much we use plsql in real time
I want load the data into target with out 1st and last record.
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What are the tasks that can be performed using sq?
what are the types of Data warehousing ?
What is the status code?
What is the use of incremental aggregation?
Teradata 
