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 |
What is flashback table ? Advance thanks
why we r using presql&postsql in source qualifier?
why do we go for update strategy tr in SCD rather using the session properties?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you handle decimal places while importing a flatfile into informatica?
why we use datawarehouse
what is diff between grep and find
Router T/R is active but some people are saying it is also passive which is exactly right?
How can we integrate different flat file data in a single mapping and with in a single execution
Mapplets can you use an active transformation in a mapplet,
Which development components of informatica have the highest usage?
how can u approach u r client