Informatica FAQ

Hi
Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....

convert excel file to .csv and then csv to text file...then u can take the source as flatfile..

by using Lookup transformation
LKP Logic

in Condition port Sal and sal>hisal with this Condition we can join two tables

we can do it by taking lookup transformation
example you had taken is Emp table and sal grade table
LKP Logic:
in Condition port sal and sal>hisal
with this Condition we can join two tables and get the data

yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschema

NO

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

my suggestion is ETL tools having lot of demand in Market so better don't change path and try to learn Datastage or another ETL tools.

Looking at logs, we can identify which thread(Reader/ Writer/ Transformation) is taking time to process. Below are the options to improve performance: Mapping level changes--> 1. Move the filter T/f a...

optimizing the session performance is known as performance tuning.the session runs in the availabale load window for the informatica server.performance tuning can be achieved in so many ways.1.use the...

Using Store Procedure t/r call it

Create two session which points to the same mapping and parameterise the source qualifier query in a way that it picks first half record for the first session run and second half for the second sessio...

For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every r...

first thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.

A.Make the smaller source the master source.

A Tracing level determines the amout of the information in the session log.or it store the information in session log. we have 4 types of Tracing levels 1.normal,2.verbose,3.verbose data,4.terse defa...

Incremental aggregation creates a cache memory in the first run, in each successive runs, the cache is updated with new records( apart from the old records). Same cache but updated records. So you ha...

May be 18 transformations are there in Informatica. They are source qualifier, sorter, filter, router, aggregator, expression, update strategy, store procedure, sequence generator, external procedure,...

I think this is obiee question anyway , subject area is a presentation service equivalent to presentation catalog in bi server .

Measures are calculations based on facts. A measure points to a fact (such as order amount) and specifies an aggregation function (such as average or sum).

the real meaning of fact is what are all the necessary information for a business.Ex: in a business, customer,item,order,invoices tells information.calculation of amt to be paid by the customer is the...

Create a variable port : v_cume_sal=v_cume_sal+amt
output port : o_cume_sal=v_cume_sal

In Expression t/r
Create one variable Port v_cum_sal=v_cuma_sal+sal
output port o_cum_sal=v_cum_sal

BY USING LOOKUP T/R WE CAN JOIN NON EQUI JOINS

Non Equi Join is same as outer join in join transformation. So we can do by using the joiner in Informatica.

Yes we can do it

Yes we can.