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
- 19049 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
Take the source into expression and map it to instances of
target.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / naga
Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / 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 |
Answer / ram
sq---router(2 conditions which should be satisfied)---and passed to target.
will do the work
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sujana
use union transformation..connect source to multiple grps of union transformation..
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abhishek
Through normalizer it is possible just give all feild's
occurance as 2 time and link it from source. It will work.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jay
Very Simple method
QRC-----> TRGT
|
----> TRGT
Have two instance of target and
connect source to both target instances.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / subhransu panda
Through session partition we can achieve this.
Create 2 parallel pipeline and don't override the partitions in mapping properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
After SQ use Java transformation
SQ--Java transformation
for(int i=0;i<2;i++)
{
output_port=input_port;
generateRow();
}
| Is This Answer Correct ? | 0 Yes | 0 No |
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
without using emailtask how will send a mail from informatica?
need for registering a repository server
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
how the server recognises , if the session fails after loading the 100 records in to the target
What is the difference between Power Centre and Power Mart?
What are the performance considerations when working with aggregator transformation?
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Can yoU use the maping parameters or variables created in one maping into another maping?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Teradata 
