Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
- 10 Answers
- 20309 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / jay
Hi Krish,
In the question it was mentioned clearly
that he "wants to insert 4 times (Duplicate)"
that means he does not have any unique constraint
in the target table.
If he wants to insert for 100 times daily?
Do you think is it easy to run the task for
100 times daily instead of create one mapping
as mentioned by me above and run it once daily?
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is an unconnected transformation?
What are the differences between source qualifier and joiner transformation?
What are the uses of etl tools?
How can you validate all mappings in the repository simultaneously?
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 .
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the use of transformation?
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
Explain incremental aggregation in informatica
Scheduling properties,whats the default (sequential)
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the difference between informatica 7.0 and 8.0?
Which transformation should we use to normalise the COBOL and relational sources?
COM components can be used in Informatica
