if soource is having 10 records how will u insert 20
records to target
- 6 Answers
- 11110 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sreekanth
select * from table_name
union all
select * from table_name;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
can u give example for factless fact table
How to create the source and target database connections in server manager?
How can we store previous session logs?
What do you mean by enterprise data warehousing?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Mention some types of transformation?
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
what is mean by complex business rule ?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the tuning lookup transformation - informatica
Define enterprise data warehousing?
What is a snowflake schema?
