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
- 19034 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 many ways you create ports?
what is fact and what types of fact tables is there
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How can you validate all mappings in the repository simultaneously?
why we are using surogate key in real time give me explanation
What is meant by active and passive transformation?
In update strategy target table or flat file which gives more performance ? why?
Can we have a Mapping without a Source Qualifier?
Different circumstance which drives informatica server to expel records?
Write the advantages of partitioning a session?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Can anyone please distinguish what is Inner join and Outer join
Teradata 
