if soource is having 10 records how will u insert 20
records to target
Answers were Sorted based on User's Feedback
Answer / sreekanth
select * from table_name
union all
select * from table_name;
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / priyank
Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).
SQ1 --> UNION --> EXP --> Target
SQ2
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saravana
we can user Normalizer transformation, to convert a row into double row and then load it into target
Is This Answer Correct ? | 0 Yes | 0 No |
How you can differentiate between connected lookup and unconnected lookup?
can we see default group,when we use router?if yes how?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Can any one explain or sujjest some sites for scd mappings.Thank you
What is polling?
can anyone explain me about sales project in informatica?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
How can yoU create or import flat file definition in to the warehouse designer?
How can we eliminate duplicate rows from flatfile,explain?
how remove 1st 3 records & last 3 records in informatics
What is A cache?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?