Interested to Buy Any Domain ? << Click Here >> for more details...
my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 19048 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vidyasagar
just use the below query in SQ override:)
select * from table
union all
select * from table
Regards:
Vidyasagar
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Define mapping and session?
Explain sessions and how many types of sessions are there?
How to do the error handling of if ur source is flatfiles?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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
What is rank index in rank transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
explain about unit testing? in real time?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the components of Informatica? And what is the purpose of each?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the way to execute pl/sql script using informatica mapping?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Can we create two repositories on same database instance in oracle?
