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
- 18693 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 |
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
How to load relational source into file target?
What is a difference between complete, stop and abort?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
Diffrence between static and dynamic cache
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
scenario where i can use only concurrent execution of workflow.
What is the need of building a data warehouse?
Explain pushdown optimization and types in informatica
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Teradata 
