Interested to Buy Any Domain ? << Click Here >> for more details...
if i am having 10 records in source, i want 20 records in
target...how will you do it
- 13 Answers
- 18625 Views
- BirlaSoft, IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
In informatics server which files are created during the session rums?
How can we use mapping variables in informatica?
What is olap (on-line analytical processing?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Define sessions in informatica etl?
Explain what are the different types of transformation available in informatica.
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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Is there any way to read the ms excel datas directly into informatica?
generate date / time dimension in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is primary and backup node?
Define filter transformation?
