my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 16047 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 |
How to load relational source into file target?
how to improve performence by using sorted input in aggrigator t/r.
How to load the data from people soft hrm to people soft erm using informatica?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
what is metadata?
Mention few power centre client applications with their basic purpose?
How can u work with remote database in informatica?did you work directly by using remote connections?
What is confirmed dimension with scenario
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
What is the Hierarchy of DWH?
what we require for D.modelling?
What is facttable granularity?
Teradata 
