Answer Posted / mkselva
A place where data is processed before entering the
warehouse
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by query override?
How to create or import flat file definition in to the warehouse designer?
what is the complex transformation you used in informatica
Global and Local shortcuts. Advantages.
What is a rank transform?
What is a repository manager?
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 an aggregator transformation?
What is deployment group?
How would you join a node to the already existing domain?
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
Where can we find the throughput option in informatica?
What are active and passive transformations?
What is dimensional table? Explain the different dimensions.
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