Hi,
You can use lookup transformation to identify the records presents in the target table.
here target table will be lookup table.after that you can put one router to insert/update new records
...
Type: Posts; User: reetasharma108; Keyword(s):
Hi,
You can use lookup transformation to identify the records presents in the target table.
here target table will be lookup table.after that you can put one router to insert/update new records
...
Number of the ETL tools are available for the data warehouse like
1.Informatica
2.Data Stage
3.Abintio
Data Warehouse is collection of data from different operational systems in to one place.we can read,write,modfy the data as per requirement similar like the database.but main difference between...
you can import this in source analyzer and make use of it as source.
In designer> source analyzer> import>XML_File
Centralized DWH means all the related data (collected from different ODS) is place in one database.rather than in a seperate DBs.
centralised dWH means all the datamarts used to load DWH are placed at one centralised location.
Reeta
for this you can create target as an flat file,either fixed width or delimited.
In the warehouse designer there is option for target.go there and click on create option.there you can choose flat...
yes
we can do that.import those file using the import tab in mapping designer.
Reeta
Hi,
I have unix directory, where i got different number of files daily.
Now i have to read these files using informatica.I cant use variable or parameter.
can anybody suggest me any idea for...
Connected transformation:- this transformation will connect to other tansformations in mapping and will take input from pipeline.
Unconnected:-it is not connected to pipeline. input to this...
for this create the source partitoning and make three targets on the base of key range.In the session properties we can define the sql query with key range so tht each qualifier read only tht range...
I will take but make sure database is oracle.
ya sure can do that.for retrieving from a dimension(table) it is not necessary to have join on that.u can use simple select statement.
First if you want to make duplicate records in target table then u can drag those columns from source qualifier to target table two times, But please make sure tht there should not be any type of...
login to the inormatica repository then go to required folder.after thar right click on the required workflow, there will be an option of stop. chosse it,then ur workflow will stop and hence one...
Execution will stop as soon as exception occur in procedure b.
ya we can use view in procedures
Hi,
For getting second highest number u can try following query:-
select unitprice from (select rownum r, unitprice from (select unitprice from products order by unitprice desc)) where r=2;
Hi,
syntax for query is:-
select salary from emp_table where salary between 70000 and 100000
and salary_4_day between sysdate-90 and sysdate;
HI,
As soon as u enter any SQL query, internally three processes occur:-
1.in first process the syntax error is checked.
2. second process is called parsing,in this oracle check whether the...
hey Lucy,
If you dont mind can you please tell me the 5 diffrence u know?because i know only one.
By using Router transformation of the informatica u can do this.
in router u can give these three condition and defined ur target in user defined output group.on the behalf of the condition the...
select * from table_nm where column_nm in(select col_name from table_name group by col_nm having count(1)>1);
for example:-
select * from emp where job_id in (select job_id from emp group by...
ya u can do that..................
As u r saying you have inserted new column so for inserting the values in that column u can use following:-
update emp_table set LOC='ABC' where emp_no=123;
...
Hi,
It is not possible to get the table name by taking the reference of a column name.