my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
Answer Posted / 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 |
Post New Answer View All Answers
What is lookup transformation?
What is the sql query overwrite in source qualifier in informatica
wat are deployement groups in informatica, how it will be used for developers
What is a standalone command task?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the different lookup cache(s)?
What are different types of transformations available in informatica?
How do you convert single row from source into three rows into target?
What are the advantages of informatica?
What is fact table? Explain the different kinds of facts.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Describe data concatenation?
How to generate sequence numbers?
What is dynamic cache?