Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4988 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
What is union transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
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
What is mapping debugger?
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
How an expression transformation differs from aggregator transformation?
What is a surrogate key?
Briefly explain the aggregator transformation?
How do you change a non-reusable transformation to reusable transformation?
How to extract sap data using informatica?
What are the settings that you use to configure the joiner transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to implement security measures using repository manager?
Differentiate between joiner and lookup transformation?
